SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 MDW
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 07/25/2013 :  10:27:19  Show Profile  Reply with Quote
Hi guys,

At my work place our database administrators are taking care of all the high level work - pretty much ensuring that servers are running - and we have no visibility into the internal workings of the databases. Sometimes it backfires as things start to slow down or we run out of space and we start to react at that time.

In an attempt to be proactive we recently started looking into "SQL Server 2008 Management Data Warehouse" http://msdn.microsoft.com/en-us/library/dd939169(v=sql.100).aspx. This tool, once set up, would monitor 3 things:

- Query performance statistics and use of indexes
- Resource locking and blocking
- Disk usage

Is anyone using this tool? If so, what do you think about it?

Is anyone using some other free tools for a similar purpose?

Thanks in advance!
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000