SQL Server Parameters - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server Parameters

Author

Topic

rohitmathur11
Yak Posting Veteran

77 Posts

Posted - 2009-12-17 : 23:51:42

Hi,
I am using SQL Server 2008.
I want to know what all settings or paremeters we can set to improve
database performance.
From where we can change default value of paremeters...?
Total how many paremeters are there in sql server 2008.

Any idea..?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-18 : 00:39:10

I enable lock pages in memory, turn down max degree of parallelism, set the memory appropriately, and switch to read_committed_snapshot.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

rohitmathur11
Yak Posting Veteran

77 Posts

Posted - 2009-12-21 : 00:25:07

Where we can find all parameters in the sql server 2008.

Like in oracle most of parameters are in 'pfile' and we can change
there default values for tunning .

same where i can find settings or ....
for performance tunning ....

any idea..

svicky9
Posting Yak Master

232 Posts

Posted - 2009-12-21 : 16:24:29

Lock Pages in Memory - http://technet.microsoft.com/en-us/library/ms190730.aspx
Max Degree of Parallelism - http://technet.microsoft.com/en-us/library/ms181007.aspx
set the memory appropriately - http://msdn.microsoft.com/en-us/library/ms178067.aspx
Read Commited Snapshot - http://msdn.microsoft.com/en-us/library/ms173763.aspx

FYI - Just search on MSDN and technet

http://www.sqlserver007.com

behrman
Yak Posting Veteran

76 Posts

Posted - 2009-12-26 : 08:17:21

Hi.
Please refer to the url below:
http://www.databasejournal.com/features/mssql/article.php/1436951/SQL-Server-Settings-Optimization-Tips.htm
I think it will be helpful for you.
Regards,
behrman.

RAQ Report: Web-based Excel-like Java reporting tool

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources