June 24, 2002 at 2:01 pm
How can I schedule to start and stop SQL 2000 on a Windows 2000 server?
The memory used by SS on the Win 2000 server is increasing. I was told that this is a known Microsoft bug and the workaround is to stop and start sql server. I was told that this can be scheduled in the operation system.
Thanks in advance for your help.
June 24, 2002 at 2:25 pm
You can run a batch file that executes net start or net stop. Not sure which bug you're referring to, do you have the Q#? It's normally for SQL to use more memory as it continues to cache plans and data.
Andy
June 24, 2002 at 2:27 pm
as andy said, create a batch or .CMD file. In it do a "net stop mssqlserver" and a net start mssqlserver (or whatever the service is named).
The NT AT or W2K Scheduled tasks can easily run this.
Steve Jones
June 25, 2002 at 7:07 am
Thanks.
I don't know the Q#. I was told by our resident SQL Guru that this was a bug - SQL Server not releasing the memory after it finishes a task and allocating more memory for the next task rather than use what it already has. The Committed memory on my server went from 18MB to 105MB in a 15 hour span.
I tried the net stop and start and it worked.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply