homebrew01 (1/10/2009)

---

Perry Whittle (1/10/2009)

---

homebrew01 (1/10/2009)

---

Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM...

homebrew01 (1/10/2009)

---

Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM overhead, but not...

colin Leversuch-Roberts (1/9/2009)

---

On one san I have aligned partitions with 64kb block size, 128kb stripe, raid 10 dedicated spindles; I also have some 4kb block size non aligned partitions also...

click in the combo box and type a new database name 😉

if you right click at the "databases" node of the tree view the combo box should be empty when...

the only caveat here is unless the...

John

cant find the link at present, it detailed the NTFS cluster size and disk alignment within the windows OS. MS indicated that changing default cluster sizes,etc didnt necessarily boost performance.

I've...

Wow, some great responses here. Did I open a can of worms? I appreciate all the feedback both negative and positive. This was only ever meant to be a "quick...

option 2 should include the client

ALZDBA (1/7/2009)

---

Still the log data is needed in case sqlserver crashes of in case of power failure of the server only to be able to restore the database into a...

this is the key here, it should and generally does but there can be instances when it...

BOL sql2005 Dec2008 is the version

as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run the checkpoint...

the correct syntax to use is

servername\instance

check your index widths too, depending on the columns included indexes can be quite large

also instead of re creating and syncing the logins use the following link

http://support.microsoft.com/kb/246133

to move logins between servers, preserving the database to user relationship