[AccessD] Is it possible to see what SQL Server is doing (fromAccess)?

Asger Blond ab-mi at post3.tele.dk
Fri Aug 20 18:26:18 CDT 2010


Brad,
SQL server Profiler is the build-in tool for this.
Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Brad Marks
Sendt: 20. august 2010 22:30
Til: Access Developers discussion and problem solving
Emne: [AccessD] Is it possible to see what SQL Server is doing (fromAccess)?

I am fairly new to the world of using Access to get at SQL Server data.

Is there an easy way to see how SQL Server is processing an SQL
statement that is being sent to it from Access (Pass Through Query). 

We have several queries that run in less than 1 second but one similar
query takes 30 seconds. We would like to be able to see what SQL Server
is doing with hopes that we might be able to make this query run faster.


Thanks,
Brad

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list