Solved

SQL Server 2008 R2 slow processing

Posted on 2010-11-25
9
1,600 Views
Last Modified: 2012-05-10
I have a Windows Ent 2008 32-bit installation with SQL Server 2008 R2 std edition running. The problem is that runing jobs on this installation is slower on faster hardware than on an older server with windows 2003 and SQL 2005. I have more memory allocated and they are faster processes, yet the new setup is about half as slow with the same data and same job.

I had a mirror enabled which I disabled to test, reduced log files by changing recovery model from Full to Simple and shrank the files, I have tried enabling boosting SQL priority for processing in the SQL server properties. I have also run the performance tool included with SQL, there were no advised improvements suggested for the database or server.

Are there any suggestions I can do further to improve the performance?
0
Comment
Question by:IT_Techno
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 10

Expert Comment

by:Humpdy
ID: 34215818
how is your database files setup. Are your data and transaction logs on separate disks.
Do you know notice high CPU usage ?
Is the tempdb set to Autogrow.
Add another data file for the tempdb if you have multiple processers.

Have a look at activity monitor or sys.sysprocesses to see if there are any blocking transactions.
Put on SQL Profiler as well to see if it's any particular queries which are taking time.
0
 
LVL 5

Expert Comment

by:logideepak
ID: 34215839
What are the hardware configurations of both the servers? Additionally, what is the sql server memory usage on the new server?
0
 
LVL 8

Expert Comment

by:WesWilson
ID: 34219683
Disk type, RAID configuration, and memory size could be factors also. Try to get the specs from the old server and the new one to compare.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:IT_Techno
ID: 34228324
I will get the HDD drive info shortly and pot it, the new server has 2 x 500GB SATA drives mirrored. There is 8GB memory in the new server, SQL is using about 3.5GB of memory. There is no high processing, network or relative disk processing during normal use, I suppose I should monitor this during the Job that is specifically slow. New server is just idling.
0
 
LVL 5

Expert Comment

by:rotech_IT
ID: 34235305
Does the new server mirror those SATA drives using software RAID?  If so, that'll slow things down significantly.

I'd be interested to know if the old server was using a RAID controller, and if the new server is using Software RAID.
0
 

Author Comment

by:IT_Techno
ID: 34236455
The old server has SATA drives as well. Both new and old servers are using hardware RAID. I just found out, because I do not have access to the old server, that the old server is running Windows 2003 64-bit edition, new server is on Windows 2008 32-bit edition. I can only see this difference. I will try test the performance on a Windows 2008 R2 64-bit edition with SQL 2008 R2 64-bit edition.

Note: the database is from an older SQL2005 installation and copied, will this make a difference? I see that the database is running in SQL 2005 compatibility mode, should I change it?
0
 
LVL 5

Expert Comment

by:rotech_IT
ID: 34236612
Compatibility mode will not make a difference in this case.  Compatibility mode is just so that newer versions of SQL Server can properly handle databases created in older versions of SQL Server.  Basically....

64-bit will make a considerable difference in performance.  I've seen this first hand, 32-bit vs 64-bit is night and day.  We run all of our SQL Servers on 64-bit and I recommend that if possible, you do the same.

Best of luck.
0
 

Accepted Solution

by:
IT_Techno earned 0 total points
ID: 34280849
Problem found here is the program used is programed in an old edition of VB6. Works well on old editions of OS, but not new. I recomended the programer to upgrade his program package and re-program to improve the performance on new OS. I bench marked the installation with third party tools, and got a maximum of 18,800 transactions per second off the server, so to me, that is good enough.
0
 

Author Closing Comment

by:IT_Techno
ID: 34317325
Resolution foun not be SQL performance, but programming errors.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Load Fact table in SQL Server SSIS package 14 47
SCCM 2012 Queries 2 16
Sql server query 8 21
SQL query joining 6 tables in asp.net 4 33
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question