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 |
|
fvinagre
Starting Member
29 Posts |
 Posted - 2005-01-14 : 04:34:06
|
| Hi DBASTwo weeks ago i attached a DB from SQL server 7.0 to SQL SERVER 2000, folowing instructions i check the consistency and i recreate de indexes. The datbase size is about 120 Gb.The Database opens fine, and the server looks fine, but during the normal use of the server (VB App making querys). The proccessors fill up to 100%. And the sever are too busy to respond any sql request.I restarted the server and i checked the sql log.Too many errors like this appears:Process 57:2 (878) UMS Context 0x1220C048 appears to be non-yielding on Scheduler 2.The values changing depend on errorCan you help me??RegardsFernando |
|
|
ie94mhg
Starting Member
10 Posts |
Posted - 2005-01-17 : 10:12:14
|
| You can disable this checks if you start SQL Server with the -T1260 startup parameter |
 |
|
|
|
|
|
SQL Stops Responding