Post reply

How to monitor a Production Database in SQL Server 2005

  • October 10, 2012 at 12:09 am

    #263724

    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.

  • October 11, 2012 at 4:54 am

    #1548001

    you can use sql profiler

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 12, 2012 at 4:41 am

    #1548543

    How to use SQL Profiler for monitor?

  • October 12, 2012 at 5:30 am

    #1548563

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply