Execute sp_configure 'show advanced options', 1;

Reconfigure with override;

go

Execute sp_configure; -- show all options

go

Execute sp_configure 'max server memory (MB)', value;

Execute sp_configure 'min server memory (MB)', value;

go

Jeff

John Chiu (6/18/2008)

---

Let me try it I can do better this time, below is the code and some comments

-- read client data from staging table and basd on the increment...

From SSMS: connect object explorer to the instance you want to configure. Right click on the server name and go to properties. Select the memory option.

Are you talking about SQL Server 2005 Developer Edition? Or are you just talking about the client tools?

Either way, both should be patched to the highest level of any...

To be honest - I don't know, since I have actually never set it up. I have a group who manages the servers and sets all that up before...

Just to clear this up a bit. Any service that is managed by Cluster Administrator needs to be defined as Manual. If it is set to Automatic, then...

By using three-part naming convention. I would give you an example, but I am not sure what you have tried so far and really don't know whether or not...

In Profiler - database id and name are not default columns. You have to show all columns and select the database id and/or name to include them in the...

Glad I could help - actually did not know about those samples until I went searching.

Jeff

So, what exactly are you looking for. SSMS is an application that connects to SQL Server. BIDS (Business Intelligence Development Studio) is also an application that connects to...

colin Leversuch-Roberts (6/16/2008)

---

ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it...

I guess I am not seeing the problem - since kcckey is a date column, couldn't you just do something like:

DECLARE @current_sunday datetime

,@previous_sunday datetime;

SET @previous_sunday = DATEADD(day, DATEDIFF(day, 0, getdate())...

kinnon_2000 (6/15/2008)

---

Hi,

Lets say i have two stored procedures, one callign the other to get its output into a varible. the first procedure has only one string as its output. The...

I disable hyper-threading on all of my SQL Servers. I have not found anything other than problems with having it enabled - and only rare situations where it actually...

Yes - I did look at those. And once again, you will not see how much memory SQL Server is actually using from that view. You even show...