SQL Server Performance Forum – Threads Archive
Alter database caused scheduler to hung
Hi ! This is not a question. I only would like to share my sad experiance for someone notto do my mistakes. I altered database : modified file by adding couple of G ‘s
After that without restarting server I run Reindexing,backed up transaction log.
Everything seemed to be perfect.
I never restarted the server after those actions.
I checked the log today and noticed that couple of hours after i left home
6 job ran successfully. But after that I noticed this message in sql log: Error 17883
The scheduler appears to be hung No job ran after that and SQL stoped responding. I found this article on microsoft site.
http://support.microsoft.com/default.aspx?scid=kb;en-us;810885 So I made a conclusion for my self that I have to restart sql server
after issue "Alter database modify file" operation.
Even thought book on line is not suggesting that
If the hardware of SQL server matches with the KBA referred as high-end subsystem then make sure the workaround is in place or obtain the hotfix as mentioned in the article. As such there is no requirement or necessity to restart the SQL Services after database configuration has been changed. Ensure there are no h/w issues by referring to event viewer and SQL server error log. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
There many operations with no restart recommendation. I my experience I´m shure only after restart and check that all is Ok.
Luis Martin
Moderator
SQL-Server-Performance.com
1.What is high-end disk subsystem? 2.What is hw issue?
Many disk drives (SCSI and IDE) contain onboard caches of 512 KB, 1 MB, or larger. However, the drive caches usually rely on a capacitor and not a battery-backed solution. Many vendors provide functional battery-backed caching solutions. These caches can maintain the data in the cache for several days and even allow the caching card to be placed in a second computer. When power is properly restored, the unwritten data is completely flushed before any further data access is allowed. Many of them allow percentage of read versus write cache to be established for optimal performance. Some contain large memory storage areas. In fact, for a very specific segment of the market, some hardware vendors provide high-end battery-backed disk caching systems with 6 GB or more of cache. These can significantly improve database performance. H/w issues – such as issues like performance affected while processing any request from SQL server. Problem with RAID disks. Any information will be recorded to event viewer. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thank you.
Yes we have high-end disk subsystem.
No h/w issue.
]]>