Not sure how to add the T1118 flag .... i see start up parameters but not sure how to put it in

Here the post i was following:

http://support.microsoft.com/kb/328551/

Done all the tempdb with 4 files for 4 processors.

Guess what i now said to SQL run with 2 processors then with 4 processors...

Well i suppose its all down to the code now that being generated from our ERP system.... as i done all above. 

What is profiler CPU measured in milliseconds and...

Ok i got brave thats what a test system all about.

Added

Alter database tempdb add file (name = tempdev2, filename = 'J:\MSSQL\DATA\MSSQL\Data\tempdb_db2.mdf',size = 60Mb,filegrowth = 20Mb),

( name = tempdev3, Filename...

Hey there everyone been really busy.  Got a brand new SQL Server and brand new SAN just configured done all the IOSTRESS Tools we had

200 IOPS now got 10,000 IOPS...

Thank you for the replies...gosh this is hard

I/O speed (not the actual spin speed) of your disks and the I/O speed of the controllers.   I have to re ask our consultants this...

Our...

Let me re read the last post

First we had the first 5 slots on SAN which is used by the operating system so thats 5 disks (this is raid...

right click and do shrink database select templog

Thanks i will give it a try....

Not sure what you asked noeld Sorry.....

Thank you all for your help on this.

This is only for 2005 i cannot do this in...

If you have a screen shot of the files in tempdb that be nice

Can you post what you did on your tempdb when you say added 4 files .

I have TEMPDB

    Under Data Files 

         File Name  

              TempDev       M:\

    Under Transaction Log

         ...

Can you post what you did on your tempdb when you say added 4 files .

I have TEMPDB

    Under Data Files 

         File Name  

              TempDev       M:\

    Under Transaction Log

         ...

Thanks for replying.

Right now our TEMPDB is on raid5 along with all the operating system on first 5 disks of our SAN.

We moved some of the other database to RAID...

im looking now at DNS and see if anything thanks