Performance Monitoring tool

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Performance Monitoring tool

Performance Monitoring tool

Rate Topic

Display Mode

Topic Options

Author

Message

selvakumar.sms

Posted Wednesday, October 17, 2012 11:39 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, December 28, 2012 6:41 AM
Points: 34, Visits: 186

hi all

Good morning, can you suggest free MS SQL database performance monitoring tools?

Thanks

Selva

Every experts was once a beginners!!! every pros was once an amateur Smile

Post #1374144

IgorMi

Posted Thursday, October 18, 2012 2:34 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 1,874, Visits: 1,437

Hi,
You have plenty of them. Find them on
http://www.red-gate.com/
http://www.idera.com/Content/Home.aspx
http://www.quest.com/
...
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

Post #1374195

Grant Fritchey

Posted Thursday, October 18, 2012 6:55 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 13,371, Visits: 25,149

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1374310

SimplyG

Posted Wednesday, October 24, 2012 5:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 4:52 AM
Points: 1, Visits: 26

You can always try the Performance Dashboard from microsoft.. Tongue

http://www.microsoft.com/en-us/download/details.aspx?id=29063

This is the link for SQL Server 2008 R2 and SQL Server 2012

Post #1376423

« Prev Topic | Next Topic »

Permissions