Post reply

SQL Counters dissapear after stopping and restarting SQL Server.

  • February 7, 2005 at 1:26 pm

    #87393

    Im working in a lab environment when I routinely have to stop the SQL services and then restore 2 databases.

    The only reason I end up recycling the SQL service is something is in use and I cannot do a restore.

    The problem that I run into is, I am currently monitoring different SQL counters with another machine and after the recycle of the SQL service I can no longer see those counters. 

    I end up rebooting the SQL server which brings my SQL counters back.

    PS. I admit that I know enough SQL to do basic things and don't profess to be a educated SQL person.

    Any Ideas ?

     

     

     

  • February 8, 2005 at 4:54 am

    #541094

    This is a documented bug in SQL 2000 with SP3. We have the same problem. Fortunately it has been fixed in the forthcoming SP4 release (now in beta).

    More information on the bug can be found here. Also, a complete list of SP4 fixes is here.

  • February 8, 2005 at 5:13 am

    #541095

    You can kill all connections into a database for restore by detaching and re-attaching the database. This will kill all connections without having to stop and restart SQL.

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

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