November 28, 2007 at 9:41 pm
I have an 8-instance SQL 2000 cluster sit on SAN. Total CPU on each node is 8.
For one of the instance, it has 2 drives only. All databases are allocated on these 2 drives. For tempdb performance, will it help if adding one more data file so tempdb can split on these 2 drives? or should make 8 tempdb data files (as CPU is 8) on these 2 drives? or by spindles? or no need as storage takes care of performance by itself.
Any suggestion or related link to refer to?
November 29, 2007 at 8:10 am
I'm slightly confused. Do you mean 2 drives as in 2 LUNs? Or 2 physical drives?
If tempdb is used a lot, it could benefit from a separate LUN, but it depends on the LUN structures. If the LUNs are already spread among a number of drives, adding one might might not help.
Is there some reason you're looking at this instance? If it's performance, have you checked memory first?
November 29, 2007 at 4:13 pm
Thank you Steve for your reply.
To clarify, there are 2 logical drives/LUNs, not physical drives.
There are a lot of tempdb usage. Tempdb has 1 data file only. I am thinking whether adding one more data file on another drive could help in this case. -- seems not based on your reply.
20 GB memory on the node. 4.8 GB for this instance. It is planned this way. Not easy to get extra memory.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply