RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
- From: Jason Wilson <JasonWilson@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Jun 2008 06:20:01 -0700
Thanks for the reply. I have seen 3 of these unrelated boxes with this OS
and version of SQL perform terribly on different hardware configs. Something
is just not right, and these kinds of problems usually aren't too hard to
find when the problems are this prevalent. There has to be some basic setup
things for 64 bit that folks are missing.
Jason
"Linchi Shea" wrote:
If you are suspecting performance problem with the box, I'd suggest.
benhcmarking each aspect--CPU, memory, disk, and network, and compare the
results to some other box that you have used for a while and are comfortable
with. For instance, you can use the stream benchmark to measure the memory
speed on the box, and check if there is any issue with reading from memory to
the registers or writing to memory from the registers.
If the box itself checked out fine, then move on to runnign SQL Server on
the box.
Linchi
"Jason Wilson" wrote:
I have done all the SQL Server debugging I know to do. Memory usage,
Perfmon, Disk I/O, Pages, Profiler traces, checked locks/blocks, long running
queries by CPU and Disk I/O, updated DB stats/indexes, tuned TempDB,
truncated transaction logs. checked network protocols, checked the HOSTS
file, I have even tried clearing the cache. I don't know what the hold up
is, but these boxes are absolute dogs! Even Reporting Services seems to run
slow on these boxes to me.
Jason
"Linchi Shea" wrote:
I don't believe you can attribute the performance issue to the difference
between 32-bit and 64 bit. To troubleshoot, I'd first take SQL Server out of
the picture, and run some generic benchmarks to check the box out.
With SQL Server, I'd troubleshoot the performance the same way as usual,
i.e. to identify the performance bottleneck first: is the performance bad
because of processors, memoty, disks, etc? That may lead to the discovery of
a corresponding configuration issue.
Linchi
"Jason Wilson" wrote:
We have a new 8 proc 64 bit SQL Server with 16 GB of RAM (Windows 2003 Server
R2 Enterprise Ed.), and we are running VERY small test and the performance is
terrible. This is the second one of these servers I have seen this happen
on. The boxes perform worse than our developers 32 bit XP boxes with a
single disk drive and they run more aps than we are running on these servers.
These servers are completely different boxes from different vendors in
different places on different networks.
There is something we are missing in the setup/config apparently. Any
suggestion/ideas would be very welcomed!!! We have setup quite a few 32 bit
systems with no problems. Right now it looks like we have wasted a lot of
money on hardware and software!!! Please help!
- Follow-Ups:
- References:
- SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow perform
- From: Jason Wilson
- RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
- From: Linchi Shea
- SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow perform
- Prev by Date: Re: SQL Sever 2008 RC0 fail to install almost all services
- Next by Date: RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
- Previous by thread: RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
- Next by thread: RE: SQL Server 2005 64 bit on Window Server 2003 R2 64bit slow per
- Index(es):
Relevant Pages
|
