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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql Server Priority Urgent

Author  Topic 

valerod
Starting Member

9 Posts

Posted - 2002-11-05 : 11:29:56
Hi!
I need to set the Sql Server processor priority. How can I do that?
Thanks
Rodrigo

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-11-05 : 11:36:32
Do you mean the priority boost option? Take a look at sp_configure in Books Online ...

Jay White
{0}
Go to Top of Page

valerod
Starting Member

9 Posts

Posted - 2002-11-05 : 11:41:30
No I want to diminish the priority

Go to Top of Page

1fred
Posting Yak Master

158 Posts

Posted - 2002-11-05 : 12:06:18
press ctrl-alt-del then choose task manager. Click on process, right click on the sql server process and choose set priority, if you want to diminish it choose something below normal. You'll have to do that each time you restart your server

Go to Top of Page
   

- Advertisement -