August 6, 2008 at 8:11 am
Hi,
I am looking into the possiblity of prioritizing one database over another. The reason for this is as follows:
We have a database that is expected to deliver data as fast as possible as it is user facing (and we all know how much they moan) 🙂
We have another databsae that isn't as time critical, and so can be processed in the quiet time of the other database.
The problem comes as we are looking to host both databases on the same hardware platform.
Any suggestions on how we can prioritize queries for the more time critical database over the others?
Thanks for any help given.
Best regards
Paul
August 7, 2008 at 1:50 am
In SQL Server 2008 there is a functionality called Resource Governor, and I think this is what you would need to allocate resources appropriately between different sessions.
Resource Governor Concepts (http://msdn.microsoft.com/en-us/library/bb934084(SQL.100).aspx)
In SQL Srv 2000 (even its not the best practice) you could PIN few readonly tables for the database with higher priority. (I know, its silly idea)
August 7, 2008 at 3:08 am
Not within one instance. SQL treats all databases equally. If you need to do this, and the databases don't refer to each other, you could install a second instance and then you could set processor affinity and memory allowance separately.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply