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 |
|
igoro1975
Starting Member
7 Posts |
 Posted - 2002-08-15 : 05:04:12
|
| I am studing SQL Server.It all right - backup, restore..... but I bumped into monitoring of SQL server and I think that it is very very complicated???What can you say??? :-("I do not fear computers. I fear lack of them." - Isaac Asimov |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-15 : 07:59:05
|
| I'm not sure how much easier it can be made. The Performance monitor is a Windows NT/2000 service that hooks into just about every process you can run on the computer, and it gives just about every possible statistic you could want. Everything is well documented and you can set up to trace anything with about 3 or 4 mouse clicks. It will even create performance graphs. SQL Profiler is also extremely easy to use and totally flexible.If you haven't done any extensive performance monitoring before, then naturally it will seem a little daunting at first, and interpreting the results requires some experience too. Have you looked in Books Online under "performance"? There's a ton of information there.Other basic monitoring functions are sp_who, sp_who2, sp_lock, sp_monitor, a whole bunch of system procedures designed specifically for monitoring SQL Server. Look them up.Also take a look at [url]http://www.sql-server-performance.com/[/url], I'll let you guess what they specialize in. |
 |
|
|
Garth
SQLTeam Author
119 Posts |
|
|
|
|
|
Monitoring SQL Server - is it so complicated???