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 |
|
ulyss
Starting Member
10 Posts |
 Posted - 2003-01-16 : 07:50:43
|
| Hello,Can anyone help me on this?I'm looking for a good online explanation of the counters for perfmon.I could use some pointers for the right choice of counters for a basic performance scan.Thanx for your help. |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-16 : 07:57:09
|
| In the context of SQL Server performance, MSFT has a white paper which includes a decent discussion on which counters are most relevant to its performance. A quick search on msdn.microsoft.com should turn it up.Jonathan{0} |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-16 : 08:02:29
|
| Here is a good article by Brad McGehee.Jay White{0} |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-01-16 : 08:05:01
|
| There are a few very good books on SQL Server performance tuning. You can find links to those at: http://vyaskn.tripod.com/sqlbooks.htm#perfComing to your specific question, I would monitor the various disk queue length parameters of PhysicalDisk object. I'd look at Target and Total Server Memory conters of SQLServer:Memory Manager object. Transaction/sec of SQLServer:Databases, User Connections of SQLServer:General Statistics, Buffer Cache Hit Ratio of SQLServer:Buffer Manager, %Processor Time of Processor object etc are important as well. Also, the Memory object will provide some vital information on memory related aspects.If you are looking for any specific piece of information, let us know.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-01-16 : 08:26:21
|
| Or, seeing as you are asking on SQLTeam, you can also buy books through SQLTeam's bookstore http://www.sqlteam.com/store.asp and help support the site.Damian |
|
|
|
ulyss
Starting Member
10 Posts |
Posted - 2003-01-16 : 08:40:29
|
| ok thank you ppl.If you should find more articles and pointers,please feel free to post them on this topic. |
|
|
|
|
|
|
|
|
Performance monitor and counters