SQL Server Performance Forum – Threads Archive
Filegroups 2hi all In My Database 10 tables are accessed heavily which are very large in volume.
What i did is,i put all the cluster and non cluster indexes of that tables in diiferent file group on the same phsical disk ?dose it will improve performance? thanks Atul A Sathe
In your similar topic all have commented that changing the filegroup for heavyily accessed tables will improve performance.
It will always improve performance on seperating the tables and indexes on different filegroups and also check the disk placement and data file location with a better RAIDs. http://www.sql-server-performance.com/filegroups.asp &http://www.sql-server-performance.com/ac_filegroup_performance.asp is the best source of information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
yes it will improve the performances
Placing heavily accessed tables in one filegroup and the table’s non-clustered indexes in another filegroup on different physical disk can improve database performance, because it will allow seperate threads to access the tables and indexes. However, a table and its clustered index cannot be seperated into different filegroups as the clustered index determines the physical order of the data in the table. /* SKChandra */
Placing data in another filegroup on the same physical disk, should yield you nothing. —
SQL Server MVP