hisakimatama (4/29/2014)

---

If all you're looking for is to gobble up some memory...

SELECT NEWID()

FROM sys.columns A

CROSS JOIN sys.columns B

CROSS JOIN sys.columns C

That should chomp up a good amount. Just ran...

Thanks Eric but when I set the Min and Max memory, it actually does not change anything at all. I am looking in Task Manager, at the sqlservr.exe process. The...

Thanks Eirikur, but I am looking to fill up the memory that is already allocated to this SQL Instance. Say you adjust the memory to 4GB as you've show, what...

So it is hard for me to run sp_who3 on these servers because they are in production, and if I make any permanent changes at all, I have to go...

Thanks for all the comments. These are two servers in an Active/Active cluster. Each has 96 GB RAM, and dual 6-core Xeons, meaning 12 real cores, and Hyperthreading is on,...

When y'all say use sp_who3, which one do you mean? I found a bunch of different versions just by doing a google search:

http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

http://mrdenny.com/applications/sp_who3

http://www.sqlservercentral.com/scripts/SP_who3/69906/

Thank you, but when I look in Task Manager, the Image Name with the highest CPU is not surprisingly sqlservr.exe. And that is hovering around 99%. So I need...

Here are a couple other tools.

Again, I can't change anything on Prod servers, even configuring MDW isn't allowed, and I've found it to be extremely useful...

Configure the Management Data...

Thank you all, these are very helpful!

This is a production server, so I can't make *any* changes like installing software, not even Who is Active.

But what I can do is...

Bill (fluffydeadangel) (3/28/2013)

---

in our clustered environment, under sql server config, we set our IP's (we have 3 per box) in as normal... and we set IPAll to show port 1433....

You said this database is Read Only?

If so, there should be no reason why you can't set it to Simple Recovery Model, then Shrink the Transaction Log file down to...

OK, I've got what I need now. Again, pretty much thanks to Gail!

My question was: how do I find the Instances that are running on this Node of this cluster?...

Thanks Gail!

I had to 1. actually create the SP over on the other server first, 2. add in both single-quotes and parentheses around ('FixMemory'), and 3. also put in a...

I was looking for a way to find out which Instances are running on which server programmatically, so that...

I asked one of our Domain Admins, and he said:

- The domain functional level is at 2003 (even though servers are 2008).

- AD and DNS are integrated.

- Yes we do...