December 19, 2007 at 10:16 pm
hi,
recently we moved all database from sql server 2005 to new sql server 2005 .only one application is responding very slowly while selecting, update and insert also after moving. two days back i moved to old server. it's working fine . i don't known the reason. the application was developed in vb.net
in old server, RAM 2 GB, WIN 2003,100GB HD
in new server ,RAM 4 GB ,WIN 2003, nearly 400 GB
can anyone suggest on this one.
regards
kumarp
December 20, 2007 at 3:05 am
well we can run through the usual supects;
updates stats
updateusage
checkdb
auto close off
auto stats on
rebuild indexes
fragmentation of files and disk system
your application has some poorly indexed tables
plan re-use for diverse result sets
it's so much like a needle in the haystack, especially if it's application/code based.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 20, 2007 at 4:32 am
To add to that
IO contention from different file placement
Network settings (full/half duplex, auto vs specified speed)
CPU contention with other apps running on the server (if any)
Have you checked what's running slow (profiler) or for abnormal resource usage (performance monitor)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2007 at 6:54 am
How did you move? Backup/restore? Statistics usually comes to mind here.
December 20, 2007 at 7:19 am
You should also check silly things like the minimum or maximum memory configurations to be sure that something isn't different there. Also check the parallelism threshold and number of cpu's between the two servers. That's one that has bit us more often than I care to remember.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2007 at 11:21 am
Also is the new machine a single 400GB hard drive while the 100Gb machine was 5 20GB hard disks raided? Is the I/O system configured optimally start to finish: HBA cache settings and queue depth, RAID configuration if applicable, stripe and allocation unit sizes, sector alignment, etc, etc.
Is database server patched to the same level on both machines?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply