February 2, 2004 at 11:18 am
You should dedicate the windows server to SQL server only.
Freezing: Blocking?
Are you running SQL profiler?
February 2, 2004 at 11:38 am
Your original database server has one CPU only and queries will not be run in parallelism. Now you have new server with 2 CPUs, the query execution may be diifferent by running some of queries in parallel. you may disable the query parallel execution to setting "max degree of parallelism" to 1.
February 2, 2004 at 2:48 pm
I did last week what Allen Cui said, but now i'm waiting to see if nothing happens later, remember, my problem sometimes takes 3 or 4 days to show up. I hope nothing will happen.
I found this link, there are some explanation that i'm going to use, it could be very useful
http://www.sql-server-performance.com/sql_server_configuration_settings.asp
February 2, 2004 at 4:55 pm
Do you peform database maintenance such as reindex and statistics update regularly? Do you see memory presure after few days you rebooted the server?
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply