Post reply

Monitoring how to do it?

  • September 19, 2008 at 2:22 am

    #198255

    hello,

    I'm an oracle dba coming to sql server for the first time.

    I wonder what is to monitor in an sql server database, is there an integrated solution that emails a report depening on threshold set?

    Thanks, Maverick.

  • September 19, 2008 at 6:39 am

    #874163

    Integrated monitoring with 2005 and earlier isn't that sophisticated. You could build your own process to do this. SQL Server 2008 has a monitoring mechanism that is much more sophisticated. If you don't want to build it for yourself in 2005 & earlier, you'll need to look at third party tools like Idera.

    "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

  • September 19, 2008 at 12:27 pm

    #874412

    Idera sql diagnostics manager is what I use and it works well. Redgate also has tools.

  • September 19, 2008 at 12:47 pm

    #874418

    I'm using the idea tools as well to do monitoring. Although I'm in the process of augmenting that solution by writing some of my own.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 20, 2008 at 7:28 am

    #874591

    Thanks a lot all,

    Maverick

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

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