Post reply

Proactively monitoring and maintaining production databases.

  • October 6, 2009 at 12:34 pm

    #210560

    Hi,

    Is there any body who can give me simple nice scripts or any good tips for Proactively monitoring and maintaining production databases.

    I know i can use sp_who2,sysprocesses,profiler,performance monitor but i never used it proactively and i am also asked in interview that do you have any script you can schedule for monitoring to get report of yesterday night?

    Thanks

  • October 6, 2009 at 1:42 pm

    #1062449

    Irfan-358189 (10/6/2009)

    Hi,

    Is there any body who can give me simple nice scripts or any good tips for Proactively monitoring and maintaining production databases.

    I know i can use sp_who2,sysprocesses,profiler,performance monitor but i never used it proactively and i am also asked in interview that do you have any script you can schedule for monitoring to get report of yesterday night?

    Thanks

    How many servers do you have to monitor?

    Are they SQL Server 2005 or 2008?

    The solution depends on your answers.

  • October 6, 2009 at 2:20 pm

    #1062474

    I am upgrading SQL2000 to SQL 2005 ans SQL 2008,I will say you can say SQL 2000 and SQL 2005 for now.

  • October 6, 2009 at 2:55 pm

    #1062495

    Irfan-358189 (10/6/2009)

    Hi,

    Is there any body who can give me simple nice scripts or any good tips for Proactively monitoring and maintaining production databases.

    I know i can use sp_who2,sysprocesses,profiler,performance monitor but i never used it proactively and i am also asked in interview that do you have any script you can schedule for monitoring to get report of yesterday night?

    Thanks

    They want YOU to provide the monitoring tools coming in day 1, sounds like a cracker jack operation to me. I would have turned that question back and asked what tools they currently have and then discussed some GAP analysis. To see where we could improve their toolset.

    With 2005 and 2008 you have the default trace running but as it is configured it only pulls so much. And a larger question of what are they looking for.

    CEWII

  • October 6, 2009 at 3:47 pm

    #1062521

    It does,t matter from the day 1st or day end If you have any proactive monitoring scripts to schedule please let me know otherwise thank very much for you time.

  • October 6, 2009 at 4:19 pm

    #1062531

    What do they have already? What are they looking for? there are MANY things to trace, but only so much hardware to spare..

    We don't usually have PerfMon running unless we are actively watching for a problem, we do have montitors that watch logins and DDL changes and whether the server is up and agent is up and some hardware monitoring provided by the hardware manufacturers..

    What kind of monitoring are they looking for and how much of a server hit are they ok with?

    CEWII

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

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