Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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" 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  
 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.02 seconds. Powered By: Snitz Forums 2000