Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dja2112
Starting Member
2 Posts |
 Posted - 2008-05-07 : 17:15:33
|
| Running a 50G mdf and 26G ldf on a 2 proc. 8G Ram, 146G x 12 SAS drives all are raid 0 except for OS.While using log shipping from a production database to this server we get this error on our sql 2000 SP4 with HOTFIX 2223 that was to resolve the issue.Process 62:0 (1694) UMS Context 0x097C5580 appears to be non-yielding on Scheduler 2.These error show up while the log shipping process is restoring the trn logsRESTORE LOG [PRODUCTION] FROM DISK = N'J:\TransLog\Production_tlog_200805071245.TRN' WITH FILE=1, STANDBY=N'J:\TransLog\PRODUCTION_200805071245.tuf'Thought this problem was fixed with sp4 and with hotfix, but these errors are constent. Whenever the restore is running the trn logs to the database that is in standby.The server this is running on is an ML 570 2 procs 8g ram awe switch enable to use 6g 3g for os, lots of drives all are raid 0, mdf only thing on drive, ldf on other drive. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-07 : 17:27:36
|
| I'd contact MS to see if another hotfix is available. When your problem is due to a bug such as those fixed by hotfixes, then the call to them is free.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 21:04:44
|
| You put db files on raid 0? |
|
|
|
dja2112
Starting Member
2 Posts |
Posted - 2008-06-03 : 11:20:03
|
| rmiao, yes, for the speed increase. With 80+ people banging away at this database, the size of the database, the fact that we have log shipping setup to another server, don't see a problem with it. I know it is not something everyone would do.Next step is to go towards a RAID 10 with four drives. Have to get Administrator behind that change on that one. They do not like change. |
|
|
|
|
|
|
|
|
17883 and UMS and Non-Yielding error