November 7, 2002 at 4:00 am
I am running currently SQL2K on a server with 2 processors.
Can someone please tell me how to configure a trace on SQL Profiler which will identify when the server is carrying out SP's using both processors (i.e. in parallel (SMP)).
November 7, 2002 at 5:31 am
Check Performance Event Classes in SQL BOL.
Degree Of Parallelism1 and Show Plan Text are supposed to help, but I have never used them.
November 7, 2002 at 5:47 am
Thanks, but neither of these events populate the TextData field of the profiler. I cannot therefore easily identify which of my SPs are most costly.
November 7, 2002 at 6:03 am
Actualy look at CPU, Duration, Reads, and Writes. The higher the combined values the more costly the query is in relation to other items. Reads and Writes being have the heaviest weight as far as amount related to costliness of query. Als look for cache misses and recompiles.
November 7, 2002 at 6:41 am
These are the actual physical costs rather than the theoretical cost, that you obtain though an execution plan.
You will however need to consider the amount of data returned.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply