Hey experts,
SQL 2000 moved from a older server to a new server, both running Windows 2003 Standard. SQL 2000 and OS have been patched and updated. I copied all settings accross and moved our database over to new server. It is working, but very very slow. I have 75-80 users a day working in it and having very bad performance issues. New server is substantially faster and using more ram. What am I missing?
The database is EMR software, the EMR company is little help. They don't have a good answer and I am completely setup to thier standards and likings. I thought maybe hardware, but everything really looks good. Everything on the server is blazing fast.
From what I have gotten from the docs, the slowness occurs when moving from different fields in the software and modules. IE, going from Neurology to Ortho.
Old server was running Raid 5
New server the same
Old srv 4 p4 2.8ghz
New srv 2 quad core 3.0ghz xeons
Old srv 2gb ram
New srv 4gb ram
I dont get it, please help!!!!
Thank you
Chris
EXEC sp_MSforeachtable '
UPDATE STATISTICS ?
'
2) You would need a Windows person to do this.
4)
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'max degree of parallelism', 1
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE