| Author |
 Topic  |
|
|
arkiboys
Flowing Fount of Yak Knowledge
1341 Posts |
 Posted - 01/18/2012 : 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
United Kingdom
223 Posts |
Posted - 01/18/2012 : 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
Flowing Fount of Yak Knowledge
1341 Posts |
Posted - 01/18/2012 : 09:05:34
|
quote:
Originally posted by chris_cs
I'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
United Kingdom
223 Posts |
Posted - 01/18/2012 : 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
USA
44 Posts |
Posted - 01/20/2012 : 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
Flowing Fount of Yak Knowledge
1341 Posts |
Posted - 01/20/2012 : 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
Constraint Violating Yak Guru
India
430 Posts |
Posted - 03/14/2013 : 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/ |
|
|
| |
Topic |
|
Moitoring tool
