|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL PerformanceHi,
I would like to know if I use the % Processor Time to watch the CPU Usage, can I tell if the CPU Usage is used by what application like SQL Server? Seems like I have struggled it for a long time to figure it out. Thanks Ed Hi
I assume you are talking about the counter in Performance Monitor, in which case I don't think there is a way to know, as it does not collect information on the individual processes. Things like the process list in task manager will give you values for the running processes. In general if this is a dedicated server then most of the CPU time will be allocated to your SQL Server process therefore you will only need to know the relative trends. John Show quote "Ed" wrote: > Hi, > I would like to know if I use the % Processor Time to watch the CPU Usage, > can I tell if the CPU Usage is used by what application like SQL Server? > Seems like I have struggled it for a long time to figure it out. > Thanks > Ed Thanks.
I am talking about the counter in Performance Monitor. Unfortunately, we have an IIS and a SQL Server on the same machine. I am thinking the CPU value in SQL Profiler may be very help to determine the slow running queries as well. Is that necessary to run the Performance Monitor or the Task Manager is good enough? Thanks again. Ed Show quote "John Bell" wrote: > Hi > > I assume you are talking about the counter in Performance Monitor, in which > case I don't think there is a way to know, as it does not collect information > on the individual processes. Things like the process list in task manager > will give you values for the running processes. In general if this is a > dedicated server then most of the CPU time will be allocated to your SQL > Server process therefore you will only need to know the relative trends. > > John > > > "Ed" wrote: > > > Hi, > > I would like to know if I use the % Processor Time to watch the CPU Usage, > > can I tell if the CPU Usage is used by what application like SQL Server? > > Seems like I have struggled it for a long time to figure it out. > > Thanks > > Ed Profiler is definitely the way to go since Task Manager and Performance
Monitor just won't do what you need. Look closely at the number of reads. They will give you a clue on where to start optimizing. Keep'em low. Events to trace: SQL:StmtCompleted - time/resources needed for each statement; SQL:BatchCompleted - time/resources needed for the batch. And please move the IIS somewhere else. ;) ML Hi
You may want to read Kevin Klien's article in the June copy of SQL Server magazine http://www.windowsitpro.com/Article/ArticleID/46082/46082.html?Ad=1 about how to proactively monitor your SQL Server installation. Profiler can highlight hotspots within SQL Server, but you will have to look at Performance Monitor and task manager to see the health of the system as a whole. John Show quote "Ed" wrote: > Thanks. > > I am talking about the counter in Performance Monitor. Unfortunately, we > have an IIS and a SQL Server on the same machine. I am thinking the CPU > value in SQL Profiler may be very help to determine the slow running queries > as well. > Is that necessary to run the Performance Monitor or the Task Manager is good > enough? > > Thanks again. > > Ed > > "John Bell" wrote: > > > Hi > > > > I assume you are talking about the counter in Performance Monitor, in which > > case I don't think there is a way to know, as it does not collect information > > on the individual processes. Things like the process list in task manager > > will give you values for the running processes. In general if this is a > > dedicated server then most of the CPU time will be allocated to your SQL > > Server process therefore you will only need to know the relative trends. > > > > John > > > > > > "Ed" wrote: > > > > > Hi, > > > I would like to know if I use the % Processor Time to watch the CPU Usage, > > > can I tell if the CPU Usage is used by what application like SQL Server? > > > Seems like I have struggled it for a long time to figure it out. > > > Thanks > > > Ed  |
|||||||||||||||||||||||
Other interesting topics