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 12»»

SQL Server 2008 installation Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 5:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Need to install SQL Server on a new box. OS installed and ready etc...

The server has two drives:

C - RAID 1 across two 46GB drives
D - RAID 5 across 3 600GB drives

The new server is not in the trusted domain so can't use AD accounts.

See below of another server that was configured by someone else a few years back but I don't like the fact that the services are using the Administrator account?!



So my plan for the SQL Server installation is as follows:

1) Create new local accounts and let SQL Server assign the required permissions.
2) Ensure Anti-Virus software skips .MDF, .LDF and .NDF files
3) Enable Instant File Initialisation.
4) Use drive C for SQL Server installation and drive D for .MDF and .LDF files (including TempDB).

Is this okay?


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386318
Posted Monday, November 19, 2012 6:17 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: Friday, April 11, 2014 6:50 AM
Points: 517, Visits: 346
Logs and data on the same drive is NOT a good setup - it's bad for both performance and integrity.

Also, while I have no objections to placing the installation files on C:, you should generally avoid placing databases there as bad things happen to your entire server if you actually fill this drive.




Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1386341
Posted Monday, November 19, 2012 6:29 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Vegard Hagen (11/19/2012)
Logs and data on the same drive is NOT a good setup - it's bad for both performance and integrity.


Sure.... I agree but I didn't build the server so I'm not sure what the best way to deal with this.

As it stands I have 5 physical drives in the server:

Drive 1 & 2 = RAID 1 = 36GB = C drive (I'm using this for the OS and SQL Server)

Drive 3, 4 & 5 = RAID 5 = 600GB = D drive (Use for .MDF but where to put .LDF?!)


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386352
Posted Monday, November 19, 2012 7:59 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Not sure if I'm explaining this properly but I have 5 physical drive.

2 physical drisks map to 1 logical drive C - This I'm using for OS and SQL Server

3 physical disks map to 1 logical drive D - This I want to use for .MDF and .LDF

Is it worth creating additional logical drives so my files would split up like the below:

Drive D - .MDF files
Drive E - .LDF files
Drive F - tempDB .LDF file
Drive G - tempDB .MDF file
Drive H - .NDF files

Somehow I think it won't make a difference as these additional drives are not physical drives but does anyone know if I can get better performance by having these extra LUNs?


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386413
Posted Monday, November 19, 2012 8:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 4,942, Visits: 8,864
Logical drives wouldn't help performance nor recoverability, just manageability.
Two separate drives for tempdb data and log is overkill IMHO.
See here a for a nice SQLServer installation checklist: http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/03/22/sql-server-installation-checklist.aspx

Hope this helps
Gianluca


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1386421
Posted Monday, November 19, 2012 8:35 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Thanks Gianluca,

So I'm looking at the pre-installation checklist and there's one point I'm not sure I understand.

2. SQL Server Admins Group added to the Local Administrators Group.

Can somone explain?


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386432
Posted Monday, November 19, 2012 8:39 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 4,942, Visits: 8,864
You can read it as "DBAs group added to local administrators group".

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1386436
Posted Monday, November 19, 2012 9:18 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Gianluca Sartori (11/19/2012)
You can read it as "DBAs group added to local administrators group".


Ah but this is only valid for a server that's in the domain which mine isn't. Have I understood this correctly?

Also, if you don't mind me asking another question:

For the built in SQL Server SA account, can I use the local server Admin as the user?


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386452
Posted Monday, November 19, 2012 9:26 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: Friday, April 11, 2014 6:50 AM
Points: 517, Visits: 346
Well, if your server is not in a domain, you will probably need an equivalent local group on this server.

I agree with SpaghettigDBA regarding disk config for tempdb: While it is nice to have a dedicated tempdb drive on large production servers, you don't need to split that up into separate drives for log and data.

As for your "I didn't build this server" comment... well, this is a known problem: people building servers without proper consideration of their actual config and purpose. Contrary to what a lot of people seem to think, 600 GB of disk is not just 600 GB of disk.




Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1386457
Posted Monday, November 19, 2012 9:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
Vegard Hagen (11/19/2012)

I agree with SpaghettigDBA regarding disk config for tempdb: While it is nice to have a dedicated tempdb drive on large production servers, you don't need to split that up into separate drives for log and data.


Fair point but I've created 3 folders on the new D drive, SQLData, SQLLogs and SQlBAckups. TempDB is going on the same drive as the everything else. What else can I do?!

As for your "I didn't build this server" comment... well, this is a known problem: people building servers without proper consideration of their actual config and purpose. Contrary to what a lot of people seem to think, 600 GB of disk is not just 600 GB of disk.


You should see how the other servers are configured... lol not to mention the number of people who know the Domain Admin account password! ROFL.....

Well, if your server is not in a domain, you will probably need an equivalent local group on this server.


Can you please expand on this a little more? I don't funny understand the need for the group. Why not just user the local Administrator user account for the SQL Server SA?


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1386464
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse