RE: Optimize for performance

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: SatyaSKJ (SatyaSKJ_at_discussions.microsoft.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 06:23:01 -0700

Bunch of articles I would like to propose to read thru:
http://www.sql-server-performance.com/database_settings.asp
http://www.sql-server-performance.com/sql_server_configuration_settings.asp
http://databasejournal.com/features/mssql/article.php/3114651
http://www.sqlteam.com/item.asp?ItemID=1452

HTH
"adoyt" wrote:

> We one Large database (100 GB) and two small databases (30
> GB each) that are used often for reporting. The server is
> about to be connected to the SAN. Would it be best to
> have one large drive or seperate drives for each
> database. Again, only one SAN connection.
>
> Here's the way the server would look:
> C:\ - System Partition
> E:\ - Application Partition - (SQL Installed)
> G:\ - Databases - 300GB
> L:\ - Transaction Logs
> Z:\ - Page File
>
> Thanks,
>
> adoyt
>

Relevant Pages

  • Re: Adding a new server
    ... They do have a separate firewall, ... >> really safe to open up port 25 directly into the SBS/Exchange server? ... You cannot take the SBS licesnce of Exchange and load it on another ...
    (microsoft.public.windows.server.sbs)
  • Re: Migrating share information
    ... > to do a fresh install of 2k3 since there is a bunch of crap loaded on the ... > the shared data is on seperate drives. ... I have looked at the file server ... You could run the batch file below on your old server, ...
    (microsoft.public.windows.server.general)