I/O subsystem - 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 2000 Forums

SQL Server Development (2000)

I/O subsystem

Author

Topic

ereader
Yak Posting Veteran

50 Posts

Posted - 2003-01-31 : 05:21:54

we are creating the database using different filegroups

CREATE DATABASE demo
ON
PRIMARY ( NAME = demo1,
FILENAME = `d:\data\demo_dat1.mdf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = demo2,
FILENAME = `d:\data\demo_dat2.ndf',
SIZE = 200MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = demo3,
FILENAME = `d:\data\demo_dat3.ndf',
SIZE = 200MB,
MAXSIZE = 200,
FILEGROWTH = 20)
LOG ON
( NAME = demolog1,
FILENAME = `e:\data\log\demo_log1.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
GO

will it be helpful for the read intensive database

we have a table named tblnew which is consuming 75% resources for the essential query how we can implement the files to achieve the i/O performance on compaq proliant series

Edited by - eReader on 01/31/2003 05:30:45

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources