October 17, 2012 at 11:39 pm
hi all
Good morning, can you suggest free MS SQL database performance monitoring tools?
Thanks
Selva
--------------------------------------------------------
I am Learner -- SQL
October 18, 2012 at 2:34 am
Hi,
You have plenty of them. Find them on
http://www.idera.com/Content/Home.aspx
...
Some are free, some are trial and/or restricted with functionality...
you can find articles about monitoring server performances on this site also...
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
October 18, 2012 at 6:55 am
Free ones? Sure, Performance Monitor is built into every Windows OS. It's the foundation for monitoring the server and behavior within SQL Server. Then, if you're running 2008 or better you can use Extended Events to monitor you query metrics. You can also use the Dynamic Management Objects built into the server to look at various metrics. None of these tools cost a thing and you can do all the monitoring you need to do with them. It only takes a little work to even set up alerts through the SQL Agent. Zero cost on all of them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2012 at 5:59 am
You can always try the Performance Dashboard from microsoft.. 😛
http://www.microsoft.com/en-us/download/details.aspx?id=29063
This is the link for SQL Server 2008 R2 and SQL Server 2012
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply