Wayne West (2/24/2016)

---

That's the thing that I wasn't sure of, if MS was still writing their OS in a 32 bit world. Sad to learn that they're still stuck...

Wayne West (2/24/2016)

---

With Windows 7, even the Pro edition, you have to get the x64 edition to use 16 gig, or any amount above 4 gig. Does that hold...

Did you ever resolve this?

Since this is the 2014 forum, I'll assume you're on SQL 2014 and suggest looking at the new system function:

sys.fn_hadr_is_primary_replica

https://msdn.microsoft.com/en-us/library/dn249345.aspx

it might ease your coding and/or...

@ around like 164 in the 2014 script, there's this:

-- SQL Server Process Address space info ...

If you don't mind me throwing my $.02 in here, the specs sound fine, but spend a little extra money and make sure you get an SSD in it. ...

SQLBlimp (2/18/2016)

---

Joe O'Connor (2/18/2016)

---

I did some more experimenting with this, and noted one omission that might be useful - including "is_disabled' in the output. As it doesn't appear to...

I did some more experimenting with this, and noted one omission that might be useful - including "is_disabled' in the output. As it doesn't appear to come back when...

Hugo Kornelis (2/18/2016)

---

The correct answer to this question is "it depends".

Now my question to you is if you can...

Wow! Thank you for this! As the "New" DBA at my company (aka the only one), noone has any idea what most databases are for or who uses...

amicusbabu (2/17/2016)

---

I have configured the AlwaysOn Availability setup in node1 , node2 and node3 .

always data will sends from node1 to third party server.

Node1 is primary,if primary is healthy no...

Great script, thank you for sharing!

On top of the Remote DAC concerns others posted, there's one small typo I spotted:

linie 1071 has "XP_fixdrdrives Enabled for PUBLIC".

Your...

I thought you had asked if you should use the Network service account, which would never be recommended.

I refer to http://blogs.technet.com/b/canitpro/archive/2012/02/08/the-sql-guy-post-15-best-practices-for-using-sql-server-service-accounts.aspx

for answering this question

Shouldn't the recommendation be to use a local server service account if it does not need access to network resources?