March 14, 2008 at 3:54 am
hello,
i have a request of 30 second on sql server 2000. i want to see with perfmon, what is the probleme, memory, processor or disk i/o. what event choose to see that ?
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 14, 2008 at 5:34 am
Since perfmon counters tend to give an overall view of the server you might want to look into using SQL Profiler instead to narrow down the search to a specific application/database: Using the SQL Server Profiler.
If you still want to use perfmon then take a look at this article: Tips for Using SQL Server Performance Monitor Counters.
March 14, 2008 at 5:34 am
I guess you have a problem with query that executes for 30 sec, but shouldn't.
Examine the query execution plan. Red nodes need work on.
March 14, 2008 at 8:59 am
hello,
you say "Red nodes need work on" but i dont understand what you want to say. I dont speak american fluently. could you translate on a second answer ?
Yann.
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
March 14, 2008 at 9:04 am
Yann
What Robert is saying is that you should examine the graphical execution plan. If anything in the plan appears in red, this is where you need to start tuning your query, adding indexes, or whatever.
John
March 14, 2008 at 9:08 am
thanks a lot... i look the query plan...
French Geek.
http://blog.developpez.com/ylarvor
I work my english 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply