August 11, 2010 at 3:54 am
Hello, I was wondering what people did when it came to the placement of the tempdb database files on multiple instance servers. If you had a server connected to a SAN, with the server having 4 processors. Would you place the 4 tempdb databases files for each instance on one disk space, or would you have each instances files on their own disk space? And where would you place the logs?
I'd be interested on hearing any opinions on this.
Regards,
D.
August 11, 2010 at 11:15 am
I have given each instance/tempdb its own disk. In setting up multi-instance/multi-node SQL Cluster environments, I use disk mount points for one. So each instance gets a mount point with Data_01, Log_01, and TempDB folder pointing to separate lun. I kept them separate because they are cluster resource.
However that said if you are running multi-instance on a standalone single sever, it might be worth having tempdb on single disk for both instances. The answer depends on the tempdb usage for each instance. If the I/O overhead from both instances is high separate them. As for number of files; are you defining any affinity mask setting on each instance to limit the number of core each instance can use? If so then decrease the number of files if not then leave assign 4 files to each instance.
My two cents :D.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply