How to monitor a Production Database in SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » How to monitor a Production Database in SQL...

How to monitor a Production Database in SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

guruprasadurs

Posted Wednesday, October 10, 2012 12:09 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 6:14 AM
Points: 24, Visits: 66

Hi,
Is there any inbuilt procedure exist to monitor a database in SQL Server 2005? or How to monitor a database? Or is there good third party tool exist.
It is very help full to me if you provided the details.

Thanks in advance.

Post #1370694

Bhuvnesh

Posted Thursday, October 11, 2012 4:54 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

you can use sql profiler

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1371352

guruprasadurs

Posted Friday, October 12, 2012 4:41 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 6:14 AM
Points: 24, Visits: 66

How to use SQL Profiler for monitor?

Post #1372011

Lowell

Posted Friday, October 12, 2012 5:30 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 11,645, Visits: 27,741

Monitoring can be a wide subject, sicne there is a lot of different things you might want to review.

redgate, the website sponsor/owner, provides some free reports you can add to your SQL Server Reporting Services:
http://www.red-gate.com/products/dba/sql-monitor/ssrs-pack

if you search for "SQL Server Monitoring" and "SQL Server Health", you'll find a lot of applications, mostly web based, that can produce some really nice reports and statistics about your servers. some are free, some are limited in order to entice you to buy the full suite, but it's certainly a start.

not many people pay attention to the built in reports:

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1372036

« Prev Topic | Next Topic »

Permissions