|
|
||||||
|
#1
02-13-08, 06:08 PM
|
|
|
|
|
I have several SQL Server 2005 Enterprise Edition database servers that have
Windows 2003 Server as the operating system. I would like to set up perfmon counters to monitor SQL Server and the server. There are numerous new perfmon counters from SQL Server 2000. What is a good benchmark counters to use with SQL Server 2005? Thanks, |
|
|
|
#2
02-13-08, 09:31 PM
|
|
|
|
|
I would suggest starting off very simple and then drilling into more
counters, DMV's, etc if needed. % CPU usage, page life expectancy,Avg disk queue can give you a quick look at each hardware subsystem and from there you can decide if you need to look deeper. |
|
|
| Similar Threads | |
| suggested perfmon counters for SQL Server 2005 Are there some suggested perfmon counters to capture while monitoring SQL Server 2005 ? Thanks |
|
| Analysis Services 2005 Perfmon Counters Hi guys, Just a quick query regarding performance counters for Analysis Services 2005. I can't seem to find an article with decent descriptions of the AS2005 counters (other... |
|
| Server 2003 64-bit not showing SQL2005 perfmon counters This has been puzzling me for a while now. When I run perfmon from the "Run" command I can't see SQL counters on the drop down list. When I run Performance Monitor from... |
|
| Perfmon counters into SQL Server table Hi Guys Anyone know how to get Performance Monitor/Systems Monitor counters into a table on SQL Server. I know you can get the SQL Server counters form Sysperfinfo, but I... |
|
| SQl server perfmon counters Hi.... We have a customer that has moved an existing DB from a SQL2K Enterprise running on 2003 Std server on a XEON 4 GB memory box, to a SQL2K Enterprise on a 2003... |
|
|
All times are GMT. The time now is 03:02 PM. | Privacy Policy
|
SQL Server 2005 Ent. Ed. Perfmon Counters