MS SQL Server - Does Disk space affect Database performance

Author

Does Disk space affect Database performance

Chris Asaipillai

2005-08-11, 1:23 pm

We have aroud 12 databases running on a live production server which is
segmented
into 3 physical drives.

The E drive is where data and logs are stored.

We have implemented a back up strategy over the past week. As a result , the
E
drive has shrunk in size.

Its a total of 135 GB but has 125 MB free.

Consequently we have noticed that various VB6 and MS Access applications are
suffering from slow performance.

But..the apps are merely querying data and bringing it back to the client.
My question is the lack of disk space affecting performance?

zashah@gmail.com

2005-08-11, 1:24 pm

The lack of disk space will cause performance problems, iirc the MS
recommendation is to not exceed about 80% capacity on a disk/disk set.

Not sure what you mean by backing up causing the disk to shrink in
size? Also not a good idea to have log and data files on the same
physical drive.

ALI

Sponsored Links