November 15, 2007 at 7:03 am
Hi All,
I am facing a problem in my personal edition of sql server 2000. my this edition is hung after some time due to error "the schedular 0 appear to be hung in sql server 2000" and next error is "the schedular 1 appear to be hung in sql server 2000" i found the solution of this error i run sp4, after that this error wont appear to me in the error log , but the other problem occur which is "your server is configure for 8 concurrent process but currently 166 process running so the performance would be degrade"
and after that i am not able to log into the server.
Due to this concurrent process problem i want to go for sql server 2000 Enterprise edition. so what stragery should i follow for upgradation of server. any other alternative of this problem
Regards
Shashi Kant chauhan
November 15, 2007 at 10:49 pm
Hi
There is a article in BOL which tells how to upgrade within a existing version of sql server. check that out.
search "editions of SQL Server" in BOL.
As far as a alternative solution goes... dont know.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply