Perf. Monitor - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Perf. Monitor

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-06-19 : 01:12:46

Hi Gurus,

I need to create a performance baseline for my company's SQL Server based on Performance Monitor counters.
What counters should I measure, and which ones are most important?

Thanks and regards
KK

Kristen
Test

22859 Posts

Posted - 2006-06-19 : 03:32:12

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=preferred+values+for+counters

Kristen

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-06-19 : 04:17:47

Thanks Kristen!

And One More Question

In our production server some times says the log file has full.

How can we solve the problem..?
is it possible to clear the log file..?
is any memory size allocated for the log files..?
Please give me the sugession

Thanks
KK

Kristen
Test

22859 Posts

Posted - 2006-06-19 : 04:21:45

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why%20is%20my%20LDF%20Log%20File%20so%20big

Nigel has information on his website too - for a link see http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=1578

Kristen

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-06-19 : 04:39:29

Thanks. I got Lot of information from Minddoor

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources