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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-28 : 23:37:49
|
| Mark writes "I want to prioritize SQL 7.0 stored procedures. I have larger ones which are a lower priority than running all the small ones. I had been awaiting SQL Server 2000 as I had heard it was going to let me allocate SQL thread priorities - like some other databases. Is there anything I can do ? It would be ideal for the bigger ones just to lumber on with a low priority. The large ones have already been tuned (they just do a lot of work and some updates). Microsoft's recommendation for big queries is to replicate the databases to another machine, which isn't what I want." |
|
|
|
|
|
Transact SQL Priority