Thanks for a great article. I tried it out and it works OK.

Now I was just wondering about backups. We use a third party tool for backups which does its...

Yes Doug, we are atully upgrading to SQL Server 2008 64-bit for the service in question.

Doug Elwood-471888 (5/16/2012)

---

Good article with a few insights:

/PAE does not do anything for a 64-bit Windows O/S.

http://msdn.microsoft.com/en-us/windows/hardware/gg487503

Also, the 32-bit address space limit is 4GB, not 2GB.

2^32 = 4294967295

AWE...

Feeg (5/16/2012)

---

(/3GB reduces the kernal memory to 1 GB and increases the user memory to 3 GB (instead of the normal 2 and 2).

/PAE enables the windowing memory functions so...

michael vessey (5/16/2012)

---

a usefull insight into the impact - there are many detailed articles on this, but none that are as simple and clear....

one thing you missed though... your...

Doug Elwood-471888 (5/16/2012)

---

Good article with a few insights:

/PAE does not do anything for a 64-bit Windows O/S.

http://msdn.microsoft.com/en-us/windows/hardware/gg487503

Also, the 32-bit address space limit is 4GB, not 2GB.

2^32 = 4294967295

AWE...

You could check the cluster.log file. use 'echo %clusterlog% to find its location

Sorry I have to come back to this. I do not have to any none-microsoft COM components but I do have OLE Automation enabled. Do I have to disabled it...

jswong05 (4/23/2012)

---

Just to clarify there are differnt operating systems:

http://www.whylinuxisbetter.net/items/defragment/index.php?lang=%5B/quote%5D

I am wondering what you are doing on SSC. Have you found a way to run SQL Server on Linux...

opc.three (3/23/2012)

---

Here is a way to find all XSPs in a user-database that were not delivered by Microsoft as part of the base installation of SQL Server:

SELECT *

FROM ...

James Horsley (4/21/2012)

---

You might want to consider using SysInternals (no part of Microsoft) contig to defrag. This is a free command line tool but allows you to specify a single...

Alexander Suprun (4/21/2012)

---

I just wonder, is 400 fragments for 300GB database file is a really-really bad thing which affects performance? It means that an average fragment size is around 755Mb....

Nice one. Will add to my kitty. "instant file initialization"

matt.newman (4/20/2012)

---

Also will dump a screen capture here just in case it is of help - off topic relates to PerfectDisk. I ran a lot of testing on PerfectDisk but...

kdburger (4/20/2012)

---

I'm just a novice, and probably shouldn't even post to this site. But, I wanted to ask what is likely a rediculous question. How did you 'extend the...