February 24, 2010 at 3:01 pm
I just upgraded a DB from sql 2000 to 2008 on the same server. The DB is less than 1 gig but I am having serious slow down issues involving I/O and network traffic. The network administrator suggested that 2008 is a memory hog and may need additional server resources. Is this a known issue with 2008?
Thanks,
Sam
February 24, 2010 at 3:06 pm
no its not. SQL 2008 optimiser uses stats differently, have you updated your stats?
---------------------------------------------------------------------
February 24, 2010 at 9:40 pm
Check the fragmentation on your indexes as well.
February 24, 2010 at 9:56 pm
Yes check fragmentation and when stats were updated, how much memory this server has?
EnjoY!
February 25, 2010 at 5:33 am
thanks, checking the stats and memory.
February 25, 2010 at 7:43 am
Have you done rebuild index and update stats?
February 25, 2010 at 8:01 am
Did you upgrade SQL 2000, or add a 2008 instance or do something else? If you have two instances, you might be eating up memory as well.
February 25, 2010 at 9:32 am
my guess is you did an inplace upgrade...can you tell what steps have you performed after the upgrade?.
February 25, 2010 at 2:35 pm
not able to remind exactly but i have seen similar post here in past(not more than a week). If you search you will get it where the problem get resolved by some -g option.....
sorry not able to remind exactly the number
----------
Ashish
February 25, 2010 at 2:40 pm
just searched and might be this topic help you:-
http://www.sqlservercentral.com/Forums/Topic707805-391-1.aspx
----------
Ashish
February 25, 2010 at 3:51 pm
I have side by side instances running and it's killing us right now.
February 25, 2010 at 3:57 pm
Have you limited memory for both instances? If not, they will be fighting for resources and causing issues.
February 25, 2010 at 4:40 pm
yes, did that and it made a big difference but didn't completely solve the issue. Now looking at server resources such as more memory, etc.
February 25, 2010 at 4:42 pm
The instances will also be fighting for disk and network i/o if they both have workloads as well, something to bear in mind.
February 26, 2010 at 3:04 am
you haven't said if you have updated your stats at least?
If you have moved a db from a sql2000 instance to a sql2008 instance on the same server the overall amount of i/o and network traffic should not change. If the memory allocation is not correct perhaps less work is getting done in memory then before, leading to more i/o, which will be slower.
Unless you are 64bit multiple instances do not tend to perform as well as a single instance unless you are very careful how you allocate memory.
---------------------------------------------------------------------
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply