Microsoft Announces SQL Server 2008 November CTP

Published On: 2007-11-19By:

New tip published: Update SQL Server table statistics for performance kick

Published On: 2007-11-15By:

Make sure that your environmentals are setup correctly

Published On: 2007-11-14By:

When you setup your data center, something that seams to be getting overlooked these days is the data center environmentals.  We all know that we need batteries and a generator for the power to keep the servers online, and that we need AC to keep them cool.  But I’ve seen a disturbing number of very large data centers who do not have the AC on the generators.  This creates a problem when the power goes out.  While it’s great that the servers will stay online the data center will quickly get up into the 100+ degree range (F).  This can quickly lead to data integrity issues is the hard drives start to fail.

 Just a couple of days ago a client of mine who hosts there servers at a company (who shall remain nameless) and their power when out for about 3 hours.  The temperature went up to 120 degrees in the data center, because the AC system which they brag about having wasn’t on the generator.  They actually called all their clients asking the clients to power down any systems which aren’t mission critical in order to save heat.  Frankly, I was surprised that the machines didn’t start to power them selves down.  I guess the HP servers are built a little more robust than I thought (not that I really want to try again).

Denny

Contact the Author | Contact DCAC

What’s the benefit of 64bit?

Published On: 2007-11-12By:

There are a several benefits of moving to 64bit hardware. 64bit hardware supports more CPUs than 32bit hardware. In addition the 64bit hardware can access way more memory than 32bit hardware. 64bit hardware can use up to 2 TB of data, while 32bit hardware will typically max out at 64 Gigs. What is especially important in that 64bit hardware does not have the AWE requirement that 32bit hardware does so all the memory can be addressed natively without having to go through the AWE driver. In addition to allowing software to access more than 2 Gigs of memory natively it allows allows SQL Server to use more procedure cache as I’ve spoken about.

The 64bit system architecture also processes math functions much faster than the 32bit system architecture. Some software is especially excellent at utilizing this additional power including SQL Server and Exchange server.

Denny

Contact the Author | Contact DCAC
1 490 491 492 493 494 495

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Award 2021 Gold    American Business Award 2021 Bronze    FT Americas’ Fastest Growing Companies 2021   INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award
FT Americas’ Fastest Growing Companies 2020       Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award
Share via
Copy link