x

sql-server-2005 disk -io

Hi,

I/O operations are distributed over the data files and log files and wait time per read(ms) is very high in my environment SQL server 2005.how can we improve the wait time per read(ms).

Please suggest

Regards, Sudhakar
more ▼

asked Mar 12 '12 at 08:31 PM in Default

sudhakar gravatar image

sudhakar
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

7 answers: sort voted first
Yes...data files and log files are residing on different drives which are SAN and tables are spread the across the datafiles
more ▼

answered Mar 13 '12 at 09:20 PM

sudhakar gravatar image

sudhakar
1 1 1 1

(comments are locked)
10|1200 characters needed characters left
No multiple instances adn databases and fragmenting the indexes based on average fragmentation value on every sunday
more ▼

answered Mar 13 '12 at 09:24 PM

sudhakar gravatar image

sudhakar
1 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1933

asked: Mar 12 '12 at 08:31 PM

Seen: 725 times

Last Updated: Mar 13 '12 at 09:24 PM