April 20, 2017 at 7:39 am
Would there an advantage creating the same number of files (e.g. 8) for all filegroups of a database ?
I want to free space in the current primary.mdf (450GB) file moving tables (heaps & clustered indexes) to new filegroups. (finally project teams have some interest in performance)
At this time I plan for 3 filegroups, separated by data domain they.
(This would make it able to reduce the mdf content to less than 40GB)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 20, 2017 at 7:52 am
No.
The 'multiple files in the filegroup' recommendation is for TempDB, not user databases.
Unless you need to spread over multiple physical drives for performance, there's little reason to have more than one file in a filegroup.
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
April 20, 2017 at 11:52 pm
Thank you, Gail
In the mean while I stumbled upon this myth article covering the topic I've been pondering over.
SQL Server Urban Legend: SQL Server Uses One Thread Per Data File ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply