I would suggest that you set a value for the max-mem setting value to say 2 or 3 GB.

Keep in mind that max-memory refers to the buffer-pool area of memory;...

Thanks again!

Pam Brisjar (3/18/2011)

---

I hear you. Had to fight some of those battles myself. But make sure you're doing your due diligence and at least presenting the information to...

Pam Brisjar (3/18/2011)

---

It could also be how you have your virtual server set up. Make sure you're following best practices as recommended by Microsoft and your VM vendor for...

Jason Selburg (3/18/2011)

---

My guess would be that it's normal. The process by which the multiprocessor uses it's available cores is quite complex (I won't even pretend to know)

But I would...

Any thoughts anyone?

fannonland2 (3/3/2011)

---

ok, changed that line back to

iWaitInMinutes = 1

iAlertFreq = 1

sAnalysisInstance = "server\instance"

sAnalysisDB = "dbName"

and the other line is now....

sConnString = "Server=" & sAnalysisInstance & ";Database=" & sAnalysisDB &...

Steve Jones - SSC Editor (3/3/2011)

---

If you have new hardware, you will install the new software on it, then move logins

Login migration: http://www.sqlservercentral.com/articles/934/

Move over databases from either a backup/restore or...

fannonland2 (3/2/2011)

---

I appreciate you taking the time to talk me through this. I am not a DBA by any stretch but I am trying to convince the DBA's that...

fannonland2 (3/2/2011)

---

ok, so it sounds like I need to go into SQL management Studio, create a new database called "Analysis" and then run the blocking tables.sql against that new...

fannonland2 (3/2/2011)

---

Hmm, then I guess I am misreading your instructions. It says I need to run scripts scom blocking.sql. I do that on the scom server? And...

fannonland2 (2/28/2011)

---

Just trying to understand what you are doing here with your scripts. I am trying to stop my IT department from buying Quest Tools or Foglight and hoping...

There are two ways you can achieve this (they can be combined into one):

EXECUTE AS clause:

http://msdn.microsoft.com/en-us/library/ms178106.aspx

Module signing:

http://msdn.microsoft.com/en-us/library/ms178106.aspx

Have a look at the above links and post further on this thread with...

I found these two links, which seem very relevant to my question:

http://www.mssqltips.com/tip.asp?tip=1114

http://www.mssqltips.com/tip.asp?tip=1306

If anyone has any additional info, it would be appreciated.

Thank you all for your responses.

This is a QA environment, so there are indeed a lot of changes happening all the time.

I will study all your answers in more...