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

Making time for the family.

Published On: 2007-11-07By:

Working in IT can be a fun and exciting career, however it can also be an extremely demanding one.  When working in IT you have to find a balance between work and family.  Without finding that balance you’ll end up with either a very unhappy employer or a very unhappy family.

Myself I am very lucky that my wife works in IT and is very understanding about the occasional long hours.  Not everyone is as lucky as I am to have someone at home who works in the field.  I can’t give advise on how to find the balance, mostly because it will be different for everyone.  I just know that it is very important to find this balance because without it, in time the work will not seam important.

Denny


Contact the Author | Contact DCAC
1 430 431 432 433 434 435

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    Microsoft MVP    Microsoft Certified Master    VMWare Partner    VMWare vExpert
   Best Full-Service Cloud Technology Consulting Company    Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link