April 20, 2013 at 1:10 pm
richykong (4/19/2013)
It looks like the standard edition only supports up to 4 processors so going to a 32 proc machine probably doesn't make a difference.
the OP doesn't say how the 32 processors are made up (how many sockets and cores etc) but thats a very good point.
---------------------------------------------------------------------
April 21, 2013 at 2:10 pm
Hi,
Interesting.
It may be your log file? Is it on same or different RAID and on what type? It's recommended to be on separate and faster disks.
It may be your tempdb? It also should reside on faster disks.
It may be the disks. Are the allocation units sizes same?
It may be the server settings?
You can make a check for these stuff.
Regards,
Igormi
Igor Micev,My blog: www.igormicev.com
April 22, 2013 at 10:10 pm
Sanz (4/15/2013)
I have a dedicated Server for SQL Server. SQL Server runs on SQL Server 2008 Standard edition with SP2 applied. The machine is a 64 bit windows machine with 32 processors and 48 GB Ram.I have moved a database from my existing UAT server to the new server(There is a drastic change in the server hardware) but can't find increase in performance when I run the same queries. What could be the reason ? Any suggestion on changes to be made ?
You forgot the MOST important piece of the performance puzzle: What is the IO configuration of each machine??
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 23, 2013 at 8:21 am
Thanks guys for the very valuable inputs.
Checked Memory, CPU, I/O etc.. and finally came to the conclusion that there is no issue with the hardware and the problem is in the query.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply