How can I increase SQL Server2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How can I increase SQL Server2005

Hi friends,
Two weeks ago, I bought new server machine and setup Windows 2003 Ent Edit. Sp1 and SQL Server 2005 Sp1. Then, I copied Sqlserver 2000 databases to new server and attached db by using T-SQL. My new machine conf.
HP DL580 – 16 Gb Ram, 4xCPU
; 5 x 146 GB HD Raid-5 on HP MSA1000 SAN How can I increase SQL Server performance by using SQL SERVER Proporties/ Option.? Notice: * On this sql server2005, there are a lot of Insert, Delete, Update transactions and selects for reports.
* Nearly 300 users logins to this server. Thanks now for helps, Ufuk,
What memory setting do you have?
The databases was compatibles with 2005?
2005 use tempdb a lot, is a good idea to put it in faster disks.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Thaks Luis, When I look at VM properties on C disk, I saw the our server Virtual Memory setting ;
Initial Size = 2048,
Maximum Size = 4092.
on C disk. Sql Server 2005 was installed on C disk. (Tempdb at the local server disk that
C:program FilesMicrosoft SQL Server 2005 Standart x64MSSQL.1MSSQLData) Is it enough if not what can I do ? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.