SQLServerCentral / Discuss Content Posted by Andy Warren / Article Discussions / Article Discussions by Author / Standards Are a Good Thing / Latest Posts

RE: Standards Are a Good Thing

Robbac — Wed, 07 May 2003 09:49:00 GMT

In my oppinion standars are very importent. I (among a couple of collegues) manage 500+ sql-servers. The servers that requier the most time from us are the ones that does not follow standard (there are a few).We've have arranged the server like follows:C: OS and SQL binaryD: SQL systemdatabasesE: Pure backupdiskF: User SQL logfilesG: User SQL datafilesH: Application diskWe have split the log-, data- and backupdisk on three different diskes in order to be safe whenever/however one server might crash or crash caused by diskcrash.And like previous commeter says, it's so easy to find information on each server. Mapping a drive and not finding the information I need there (on non-standard servers) will make me go crazy for the extra time I need to spend to find what I need.robbac

RE: Standards Are a Good Thing

ckempste — Wed, 09 Apr 2003 23:30:00 GMT

Hi thereI believe many SQL Server DBA's can leaver off the Oracle OFA (flexible architecture) in terms of structuring data/log and install directories for your SQL Server databases. Generally its all common sense though.I tend to following this:x:\dbdata\<instance-name>\<db-name>\*.*x:\dblog\<instance-name>\<db-name>\*.*this will change slightly if we are also using Oracle or another DB on the same box.The standards flow into the location of your binaries and importantly, your backup files!In terms of large numbers of DBs on a box and bucket loads of database files, its very difficult to come up with some magical solution, especially when most have very different IO characteristics. The generic RAID-5 solition is a generally a good one for probably 80% of cases (especially in hosted envs). The trick here is a large cache and leaving write/read on at the controller.CheersCk

RE: Standards Are a Good Thing

tulcanla — Wed, 09 Apr 2003 11:55:00 GMT

I agree 100%I have a data warehouse and I had to reorganise all datafile and log files , plus move msdb, tempdb from D into a less OS driveNow, when I increase the space for my files I know my limits and I don't need to jump too much between drivesI like the comment about the replicated db. I could not move that one.So now I know I have to stop the replication first :)

RE: Standards Are a Good Thing

Steve Jones - SSC Editor — Wed, 09 Apr 2003 11:06:00 GMT

Standards are important, mainly to make things easy to find. We've got 60+ SQL Servers, 30 of which I manage. We have a standard hardware setup, 3 physical arrays min for all db servers. So we have c: - OS and SQL z: - SQL data and backups y: - SQL Logsarguably it should be different, but it works. We then have \mssql\data for all mdf files, \mssql\logs for ldfs, and \mssql\backup for backups with a sub for each db. \mssql\logs holds the logs and maint reports.This is an easy way that ensures that we know where everything is. Need a report? map to \\servername\z$\mssql\logs and I've got reports. Easy to manage and find things.Steve Jonessjones@sqlservercentral.comhttp://www.sqlservercentral.com/columnists/sjoneswww.dkranch.net

Standards Are a Good Thing

Andy Warren — Sat, 29 Mar 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/standardsareagoodthing.asp>http://www.sqlservercentral.com/columnists/awarren/standardsareagoodthing.asp