O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Moving the existing large table to separate physical disk

In the previous recipe, Using Files and Filegroups, we saw that we can create a filegroup and create a table that is expected to become large and place it on different physical disks using filegroup.

But what if there is already an existing large table in an existing database that is extensively used by queries? Let's say that you are responsible for the AdventureWorks2012 database in your production environment, and there is one large table named Sales.SalesOrderDetail, which is located on the primary filegroup. You observe that the table is very large, I/O operations with a large volume of data made on this table are taking more time to be completed causing blocking issues, and other ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required