March 4, 2010 at 9:03 pm
hi ,
I am looking for a way to monitor our servers and databases.
Can anyone tell me how do you monitor your databases and servers,by manual? or automate alert? or using a monitoring software?
---------------------------------------
Thorn Bird...
March 4, 2010 at 9:54 pm
Idera Diagnostic Manager
Quest Spotlight
Confio
Those are options to purchase. Or you can develop some inhouse stuff to monitor performance counters, jobs, database files, backups, etc.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 4, 2010 at 10:51 pm
thank you ~
But the tools you list are copyright software.
Is there a open-source software to monitor my MSSQL.:-D
---------------------------------------
Thorn Bird...
March 4, 2010 at 11:10 pm
This is a free dashboard tool from Idera that I could recommend:
http://www.idera.com/Products/Free-Tools/SQL-check/
no licensing involved, but it is limited, try it.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:10 pm
Compiled applications? I don't know of any in particular.
There are a bunch of applets and scripts available for download.
Check out Glenn Berry's DMV scripts
Simple-talk.com has some SMO things to test out
SSC has plenty of tsql scripts in the script repository to help with various tasks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 5, 2010 at 12:05 am
there are many free scripts that monitor job status, performance counter, update statistics, re-indexing etc
I write my own scripts to capture data from dynamic views.
March 5, 2010 at 10:42 am
There is this tool: http://sqlh2.codeplex.com/
On SQL Server 2008 - you can also implement and use the data collector to monitor multiple systems.
There are other free tools available at the above site for monitoring SQL Server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply