Re: Query performance

Hi Phil,

Thanks for the update.

The duration of a query operation is related to several things like the CPU
usage, network connection, etc.
Also, if there is other queries executed on the same table, you may recieve
a different duration time.

As you mentioned, your SQL 2005 is on a different machine, so I think the
duration of a query will include the network connection time. The same
query will take the same time.

Performance issues can be difficult to troubleshoot and resolve in a
newsgroup setting due to the number of variables and the amount of time
required to narrow down possible causes and observe the effects. We will
assist as best as we can, but you may wish to consider contacting CSS for a
more timely resolution for these type issues.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com
for regional support phone numbers.


Thank you for your patience and understanding.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: server-side profiling
    ... Going back to the server side tracing as mentioned on the link I added to ... most especially if TEMP variable is pointing to Drive C: and that Profiler ... > a query. ... > Duration and Reads are commonly monitored together because they can both ...
    (microsoft.public.sqlserver.server)
  • question on creating time serise type of datawarehouse fac.
    ... i need some insight on some time analysis query on a transaction table. ... find out the hours (duration) for this month an airplane has been parked at ... hours time difference betweeen pacific and eastern time, ... date_id column reference key of date_dim and a time_id column reference key ...
    (microsoft.public.sqlserver.olap)
  • Re: server-side profiling
    ... Although rows are stored in tables in SQL Server, ... of a query, rows are retreived from these on-disk 8kb pages but a caching ... The Reads column in the Profiler displays LOGICAL reads. ... Duration and Reads are commonly monitored together because they can both be ...
    (microsoft.public.sqlserver.server)
  • Re: Setting the display format of a query using the DateDiff funct
    ... "RichG" wrote: ... date & time information, and the date and time difference between these ... The "Duration " query shows the following result: ...
    (microsoft.public.access.queries)
  • Re: first-prev-next-last using PHP
    ... always the same query. ... across the network connection to the DB server, how much do you want to ... why not just look at caching the page output (depending on ... saving executing most of your php and database code at ...
    (comp.lang.php)