Browse by Tags

All Tags » x64 (RSS)

x64 Memory Issues - revisited

It's funny how things seem to bob to the surface every so often, a bit like revivals of Musicals or the fact you know it's christmas becuase ET is on the TV again. Blake Morrision from the Ask the Performance Team has blogged about issues with...

ah I remember it well ! or not in this case

I've been following a few posts about the impact of filecopies on servers ( x64 w2k8 ) and how memory is affected. Now I've seen what appears to be memory being taken by file copies - I haven't fully tested this as I've only noticed on...

Windows 2008 build fun and games.

I run a number of test servers at home, these are technically PCs running a server o/s, these currently number 6. I generally build these myself with a base spec of supporting 8GB ram in 4 slots, a minimum of a dual core proc and at least one x16 pci...
Posted by GrumpyOldDBA | with no comments

How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923    MICROSOFT KB: 875352 ===========================================...

x64 Memory Problems

(  I’m hopeful that Livewriter will enable me to publish a blog post which includes screen shots as this one has a large number! ) Please READ everything and the documentation with the download before you install this I’ve blogged about memory issues...

Testing Times 1

It's an interesting time with being asked to performance test/benchmark a new server setup for a migration of sql server and data centre. Both current and new servers are SAN attached and it has been what is effectively the testing of the storage...

Cannot generate SSPI context

Now here's a slightly interesting point about this error. Although the kb does actually mention this reason for the error it is about the last thing on the article, a footnote, and it doesn't specifically word it to cover this scenario, and we...

Information Overload ??

As I've remarked before the profusion of Blogs ( from the various Microsoft teams and individuals ) whilst exposing so much more information then we ever had before also requires you to almost spend all your time just checking every blog you can find...

Configuring x64 SQL Server

I often read a number of forum posts concerning performance / configuration issues with x64 SQL Server. I've also found some interesting views on how much memory you can allocate to SQL Server on a x64 install ( I don't have any experience of...

Configuring Windows 2003 ( x64 ) for SQL Server

There is an almost constant stream of posts on forums asking about configuration of SQL Server 2005 memory, especially for x64 editions. Alongside these are also a number of posts concerning performance or perceived performance issues with x64 SQL Server...