April 18, 2007 at 6:14 am
Hello!
I would like to start SQL Server in Single User mode. I start sqlservr.exe -m -c command, but after some time, it start to write massages like :
"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 602 seconds. Working set (KB): 2532, committed (KB): 19068, memory utilization: 13%%.
...
...
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 928 seconds. Working set (KB): 2568, committed (KB): 19068, memory utilization: 13%%.
Process 51:0:0 (0x14d4) Worker 0x0392A0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12821369916747. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%%. System Idle 91%%. Interval: 70046 ms.
..."
Any idea what's wrong?
April 18, 2007 at 7:37 am
Does the same happen when you use net start with /m as well?
April 23, 2007 at 1:34 am
Yes Anders, it's the same. However, I found out, that in some point (but I'm not sure when) I can open Management Studio, and do the restore of master DB.
I still think, that baviour is not normal. ?
Besides, If I start the SQL Server with -m, and don't want to restore master, how do I stop it ???
Probably, it is stupid question, but I'm really new at SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply