June 18, 2008 at 2:08 pm
hello
I need to set instance configuration options like
min server memory
max server memory
enable clr
I found last option sql server surface area configuration. But where can I find the 1st two options?
June 18, 2008 at 2:24 pm
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2008 at 2:42 pm
I would like to know other than SSMS?
June 18, 2008 at 2:45 pm
Have a look in books online for information about sp_configure.
Matt.
June 18, 2008 at 2:46 pm
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
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2008 at 2:51 pm
Hi,
To enable CLR use Surface Area Configuration tool.
To set memory min and max check the following link[url= http://msdn.microsoft.com/en-us/library/ms191303.aspx%5D http://msdn.microsoft.com/en-us/library/ms191303.aspx%5B/url%5D
Regards
June 18, 2008 at 4:24 pm
I did not Installed client tools, So i do not have management studio. But still I need to configure min server memory n max server memory.
is there is any way to do that?
June 18, 2008 at 4:47 pm
for CLR
EXEC sp_configure 'show advanced options' , '1'
go
reconfigure
go
EXEC sp_configure 'clr enabled' , '1'
go
reconfigure
go
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '0'
go
for memory see Jeffrey post.
Regards
June 18, 2008 at 10:28 pm
Without the client tools, you will have to resort to SQLCMD, OSQL, or some other client tool. You need to be able to connect to SQL Server to make the changes.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply