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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-09-02 : 21:37:09
|
| Hi,I am working in a small organization, we have only 1 prod and 1 dev and 1 test servers(SQL2005 Standerd edition). We want to purchase a third party monitoring tool to monitor the SQL activities.Please advice, which tool is better option for this environment. |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 10:12:24
|
| Hmmmm - so budget is probably important, eh? Most of the better monitoring tools are expensive ("expensive" being a relative term to what it saves you, I suppose).My fav is Idera's DM: [url]http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/[/url]. It'll likely run you $2k per instance though...Most of us are also fans of Quest's Spotlight tool[url]http://www.quest.com/spotlight-on-sql-server-enterprise/[/url]A cheaper alternative is [url]http://www.sqlsolutions.com/products/IO%20Activity%20Monitor/index.html[/url]. It is good as well. Jeremy Kadlec has a nice write up on the different tools here: [url]http://www.mssqltips.com/tip.asp?tip=1067[/url]========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-09-08 : 14:07:21
|
| Thanks much |
|
|
|
|
|
|
SQL Monitoring tool