July 1, 2009 at 4:53 am
Dear All,
I need to add more number of datafiles into our database to get perfomance. As we are using SAP and Sql SAP recommends us to do this according to the CPU. as we are having 16 process server we have to have 16 data files. Is anybody having any procedure to do that.
Let me know .
Thanks in Advance,
With best Regards,
Chandramouli
July 1, 2009 at 5:38 am
Hi,
Can you provide us with some more information about your I/O Subsystem please? What type of storage are you using, how many disks etc.
Also are you certain that the SAP documentation is not referring to creating multiple data files per CPU for the tempdb database?
In the mean time here is some useful reading:
SQL Server 2005 Storage Top 10 Best Practices
Optimizing SQL Server Performance Using Files and File Groups
July 2, 2009 at 1:15 am
I would suggest create different filegroups first
and then create new files in those filegroups .make sure you use new physical disks if cost is not a constraint else you can use the logical disks .
here is an example :
USE [master]
GO
ALTER DATABASE [test] ADD FILEGROUP [forth]
GO
ALTER DATABASE [test] ADD FILE ( NAME = N'hello', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\hello.ndf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP [forth]
GO
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply