Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Server tuning Expand / Collapse
Author
Message
Posted Tuesday, October 19, 2010 8:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:32 AM
Points: 562, Visits: 1,036
Ok, we all know that we can change SQL Server settings to improve performance and database tuning to improve specific databases.....

Now what do we do with the servers and the OS themselves?
Dedicated SQL Server (new box)
Windows 2008 64bit Enterprise Edition
SQL Server 2008 64bit Enterprise Edition
SAN attached drives
128GB memory

going to be be around 600-700GBs of DBs transactional.

My list so far is (all require researching and testing):

pagefile - 1.5x physical memory still the base standard? obviously I dont want SQL paging
power management
background services
hyperthreading
limiting the max memory of SQL server

What else should be added to my list?
Post #1006979
Posted Tuesday, October 19, 2010 8:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 22, 2014 1:58 PM
Points: 2,281, Visits: 4,243

Windows:
Insure that "Maximize data throughput for network applications" is set instead of the default of "Maximize data throughput for file sharing"

Grant the SQL Server service account the following Windows privileges:
Perform volume maintenance tasks
Lock pages in memory

Limit the size of the System File Cache because the default is half of the physical memory.

Determine if the Windows Denial Of Service settings should be changed.

SQL Server:
Move TempDB to its own drive and add additional equal size data files.
Set the Default Database Path
Create alerts for severities 17 through 25.


SQL = Scarcely Qualifies as a Language
Post #1007027
Posted Tuesday, October 19, 2010 9:03 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:32 AM
Points: 562, Visits: 1,036
Carl Federl (10/19/2010)

Windows:
Insure that "Maximize data throughput for network applications" is set instead of the default of "Maximize data throughput for file sharing"

Grant the SQL Server service account the following Windows privileges:
Perform volume maintenance tasks
Lock pages in memory

Limit the size of the System File Cache because the default is half of the physical memory.

Determine if the Windows Denial Of Service settings should be changed.

SQL Server:
Move TempDB to its own drive and add additional equal size data files.
Set the Default Database Path
Create alerts for severities 17 through 25.


Will do some reading on the Windows items supplied... thanks

Already doing all the SQL ones, except for the Severity messages.
Post #1007036
Posted Wednesday, October 20, 2010 6:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:32 AM
Points: 562, Visits: 1,036
anything else?
Post #1007681
Posted Tuesday, December 7, 2010 1:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 11, 2010 12:33 AM
Points: 3, Visits: 1
Data Tuning results from analyzing queries (using EXPLAIN or other similar tools) to identify bottlenecks and other issues slowing down processing. Tuning the database means tweaking the structure to try and speed up processing. Probably the most common method is to add additional indexes to often-used tables. Analysis and modification of logging files may also increase performance, as may replacing triggers and constraints with explicitly-invoked procedures. Less frequent methods may include denormalization of nonvolatile data to eliminate need for joins.


Online shopping at Chinabuye for dropship electronics Service
Post #1031477
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse