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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-18 : 06:56:28
|
| Hello,We are using sql server 2008.is there a monitoring tool we can use to check the health of the sql server? i.e. tables, keys, stored procs, etc...I have heard about redgate software for this purpose.. what do you think please? |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-18 : 08:28:18
|
| We use Redgate Monitor to monitor our critical servers. We can quickly see if any of the servers have performance issues with things like CPU. It also identifies certain alerts that you can configure.I'm not sure what you mean by monitoring tables and keys?----------------------------Junior DBA learning the ropes |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-01-18 : 09:05:34
|
quote:
Originally posted by chris_csI'm not sure what you mean by monitoring tables and keys?----------------------------Junior DBA learning the ropes
I also would like to check if the tables are designed correctly i.e. indexed properly, etc. |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-18 : 09:48:26
|
| I'm not sure there is something which could monitor that.That is soemthing you'd have to check yourself. Hopefully before it goes into production!----------------------------Junior DBA learning the ropes |
|
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-20 : 11:22:45
|
| you can also use MOM , (Microsoft object Monitoring) , its very good and handy one , it monitor all the level.Sr Sql server DBA/Artitech |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-01-20 : 18:24:09
|
quote:
Originally posted by biswajitdas
you can also use MOM , (Microsoft object Monitoring) , its very good and handy one , it monitor all the level.Sr Sql server DBA/Artitech
Where do I get this from?Is this part of sql server?Thanks |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-14 : 02:51:18
|
| Brent ozar has written a great script which checks the sql server health.check it out on his blog http://www.brentozar.com/blitz/ |
|
|
|
|
|
|
Moitoring tool