Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AnitaDBA2010
Starting Member
18 Posts |
 Posted - 2010-12-30 : 13:27:24
|
| Hi All-I have been asked to set up Perfmon counters on windows server 2008 R2 (64bit) to collect data from the system. Reason to set up counters is SQL Server 2008 R2 on the server has terminated and wont start. All I am looking for is a good article, link or suggestions to set up perfmon counters to get relevant dataThanks a lot in AdvanceAnita Anita |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AnitaDBA2010
Starting Member
18 Posts |
Posted - 2010-12-31 : 15:36:50
|
| Sorry Tara, SQL server is up but I was asked to set up SQL Sever Memory related counters to collect data Below are the Memory related counters I have added so far but I am still looking for articles related to how to intrepet this data( also scheduling, sample interval time, stop condition etc)\Memory\Pages/sec\Physical Disk(_total)\Avg.Desk Queue length\SQL Server:Access Methods\Pages Splits/sec\SQL Server:Access Methods\Pages Allocated/secSQL Server: Buffer Manager: Buffer Cache Hit Ratio SQL Server: Buffer Manager: Total Pages SQL Server: Buffer Manager: Pages writes/secSQL Server: Memory Manager: Total Server Memory (KB) SQL Server: Memory Manager: Target Server Memory (KB) ThanksAnitaAnita |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
Perfmon Counter Articles or Links ?