SQL Server Performance Forum – Threads Archive
Primary file full-need to go for anothr filegp?
Hi I have a small query . First*Is there any advantage of using filegroups in different drives(C: D: etc..) ?
*same way, can we benifit anythin in creating different filegroups in same drive? Second
I have my primary file full(6GB,restricted file growth) . Should I increse the file size or add one more file to Primary file group , or create one file group and add the new file. I can use only G: drive for this, so i dont think ther is no question of seperate file group, right? Experts,Please advice . Thanks Rajiv
<br /><br />First<br />*Is there any advantage of using filegroups in different drives(C: D: etc..) ?<br /><br />Yes, If you are placing different SQL file in different disk/ Raid groups this will surely help to distribute IO and performance will increase.<br /><br />*same way, can we benifit anythin in creating different filegroups in same drive?<br /><br />NO, if you are creating many files in same drive/Raid group this will not help to distribute IO.<br /><br /><br /><br />Second<br />I have my primary file full(6GB,restricted file growth) . Should I increse the file size or add one more file to Primary file group , or create one file group and add the new file. I can use only G: drive for this, so i dont think ther is no question of seperate file group, right?<br /><br />Right, Create one more file in same filegroup and placment should be in G drive if you wish to have more IO for your database.<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br /><br /><br /><br />Deepak Kumar<br /><br />–An eye for an eye and everyone shall be blind
*Is there any advantage of using filegroups in different drives(C: D: etc..) ?<br /><br />Deepak,Can you pls ans this once again? Here i mean, a single physical disk, with different drives(c:,d:,e<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /> . As its a single phy disk with one disk controler,I think this wont help in improving perfo. wht u say .
If its a single disk with partitions then you will not get that good performance as compared to different RAID levels and disks. On adding one more filegroup ensure to transfer volatile tables to this new filegroup or to the filegroup where there is no issues of disk free space on the server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
*Satya, i didnot get wht you said about volatile tables . *Suppose i have a primary file which reached 6 gb, so extendng same or adding a new file to same group of size 1Gb. which one you prefer . and reason . THnx in advance .
*Suppose i have a primary file which reached 6 gb, so extendng same or adding a new file to same group of size 1Gb. which one you prefer . and reason . THnx in advance . I have only one Harddrive with multiple partition, so there is no question of seperate file group.And i have only one filegroup,PRIMARY .
Volatile tables – nothing but tables having lots of inserts/deletes on a regular basis.
If you can divide the database in multiple filegroups then it may have little difference in performance, have alook around on this website based on filegroup tips. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>