November 18, 2010 at 4:52 am
On one of my client's server. I have 3 databases A, B and C.
A ---> Highly transactional
B ---> least transactional
C ---> least transactional.
Tempdb has been placed on separate disk.
He asked me that can we put(keep) 50% of tempdb dedicatedly for database A.and other 50% for other DBs.so that we can get better IO usage.
So Is it possible ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 18, 2010 at 5:01 am
Think what you want is to give i/o priority rather than allocate disk space.
Also think the answer is no.
Can you put these on different instances?
Cursors never.
DTS - only when needed and never to control.
November 18, 2010 at 5:04 am
nigelrivett (11/18/2010)
Can you put these on different instances?
Nope 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 18, 2010 at 6:35 am
There is no way of restricting resource use on tempdb.
You may be able to use the resource governor to restrict CPU/Memory use but I've never implemented this so can't advise.
Careful configuration of this database should mean there isnt an issue anyway. Are you experiencing tempdb related constraints already? Have you configured additional files and preset their size? Are they seperate physical drives to the actual OLTP databases?
November 18, 2010 at 9:20 pm
MysteryJimbo (11/18/2010)
Are you experiencing tempdb related constraints already?
No
MysteryJimbo (11/18/2010)
Have you configured additional files and preset their size?
no i am dealing with the same setting provided by client.
MysteryJimbo (11/18/2010)
Are they seperate physical drives to the actual OLTP databases?
Yes user Db on different and Tempdb on separate dedicated disk.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2010 at 8:59 am
You can probably get a little bit advantage for database "A" if you create indexes on this database with SORT_IN_TEMPDB Option (http://msdn.microsoft.com/en-us/library/ms188281.aspx).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply