SQL Server Performance

Search Results

Search Again
  1. mtessier

    Multi CPU and Multi Files

    Thread by: mtessier, Oct 8, 2008, 7 replies, in forum: SQL Server 2005 Performance Tuning for Hardware
    I have 2 X 4 Cores but it looks like one processor is working hard. I know one CPU is working on one file so i would like to know if it's a good idea...
  2. mtessier

    Split Tempdb in one data file per CPU

    Thread by: mtessier, Aug 12, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions
    Hi !I read best practice on the web and I found this :It is recommended to have .25 to 1 data files (per filegroup) for each CPU on the host server....
Showing results 1 to 2 of 2
Search Again