[dba-SQLServer] [dba-Tech] X64

Gary Kjos garykjos at gmail.com
Sat Jan 5 15:56:30 CST 2008


Some guys have all the fun.

I just worked to get my Christmas decorations taken down today and the
top put up on the convertible which Ishould have done in Mid November
when I last drive it but figured I had a couple more rides yet at that
point. Then the cold snap hit. Today we have near 40 so I had my
chance to get it put up and I took advantage of it.  So I did have
some accomplishments at least. Now football is on so that will shoot
the rest of the day for me ;-)

GK

On Jan 5, 2008 2:35 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> I built a new system last night and this morning, installing Windows Server
> 2003 X64 and SQL Server 2005 X64.  The system currently has a dual proc AMD
> code but once I get the chance to wring it out I will probably move my quad
> core in there.  The system currently has 4 gigs ram but I have a matching 4
> gigs in another system which I will pull out of that system and drop in this
> one so that I can test X64 with 8 gigs RAM.  It will be interesting to see
> what effect this will have on my large databases.  I have some queries that
> take awhile to run (5+ minutes) that I can run "side by side" on the x32 and
> x64 systems.
>
> Interestingly these same queries dropped from 20-30 minutes down to 5-6
> minutes by using "cover queries" that included the PKID and a single field
> together in a single index, rather than my old method of just using that
> single field in the index (not including the PKID).
>
> The x32 system will have the same processor (different / older motherboard
> though) running Windows 2003 x32 and SQL Server 2005 x32 with only 4 gigs or
> ram.  I think I will run the same 5 minute query on both systems with 4
> gigs, then move the additional 4 gigs into the x64 system and run again,
> then move the quad core into the x64 system and run again.  This will
> provide a fairly "apples to apples" test of x32 vs. x64, 4 gigs vs. 8 gigs,
> and dual cores vs. quad cores.
>
> Unfortunately the system is low level formatting a 400 gig partition right
> now which is taking FOREVER!
>
> Once I have that 400 gig partition to use to hold the database I will run
> these tests.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com



More information about the dba-SQLServer mailing list