October 21, 2008 at 9:42 am
Hi guys,
We have our main production SQL server in a VM cluster for high availability. I just recently set up a 2005 sp2 x64 (Win2k3R2x64) box in the same cluster and migrated the databases over. Here's the config notes:
VMWare Settings:
VM: Reserved Memory 8192 MB - 1 CPU
VM Pool: Reserved Memory 12288 MB - 1 CPU @ 6144 MHz All shares HIGH/UNLIMITED
Uses iSCSI Drives - Persistent and Bound - All drives aligned.
C: SQL 2005 OS - 30GB - 12288MB Page File
D: SQLLogs - 70GB
E: SQLData - 120GB
F: SQLTestDBs - 120GB
G: SQLSysDbs - 20GB (tempdb)
SQL Server Properties:
Memory: Min:6144MB - Unlimited, Use AWE
Processor: Boost SQL Priority
Database Settings: Default Locations - E:\SQLData, D:\SQLLogs
All other settings set to default.
Database Mail configured
FailSafe Operator configured
Uses Integrated Windows and SQL Authentication - about 1000 users
Sounds weird, but I swear this thing moves slower than te old SQL 2000 server. I'm not having issues, but I swear I didn't get any performance boost whatsoever by going with SQL on x64.
Is there anything I can do to tweak the system?
Thanks!!
Tina Tysinger
MCP, MCSE, MCDBA, VCP
October 21, 2008 at 3:15 pm
HI there, have you tried the usual stuff? Like rebuilding/reorganizing your fragmented indexes or updating your tables statistics? have you check your server counters with sys.dm_os_performance_counters? what kind of waits is your server experiencing (sys.dm_os_wait_stats)?
It's weird my friend, maybe some of this things will help you out in getting higher performance. I am doing a migration from sqlServer 7.0 to sqlServer 2k5, and I can´t still get a higher performance from 2k5. I am thinking on rewriting some code (specially cursors) which are not improving my performance in spite of the fact that they run a lot faster in 7.0 :ermm: good luck! if I happen to find something I shall post it.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply