Hi
does anyone know of any good performance monitoring software for Microsoft S
QL Server 2000? How about any articles on Fine tuning your SQL server?
thanksBonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.c...nce_article.asp
http://support.microsoft.com/defaul...kb;en-us;322883
http://www.sql-server-performance.c...or_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment