April 3, 2012 at 6:41 am
Mohit:
I need a bit of help to identify our current settings ratio of read to write Cache.
It seems that you eluded to knowing how in your posting:
Many things can cause high DQL; thing you have to consider why?
For example I had a system that caused high disk queue length the
problem was not in SQL Server but rather in SCSI controller for
the RAID array. The control was set to 90% read and 10% write cache
so the Write Disk Queue Length was always through the roof.
After we got that changed to 10% read and 90% write;
the DQL improved dramatically.
April 3, 2012 at 1:10 pm
Hi,
I am sorry I can't tell you how to check that setting on your SCSI controller; I had my SAN guy do it. That time the SAN was also dedicated to SQL Server, what is your scenario?
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 4, 2012 at 7:11 am
Hey guys - PLEASE don't post to a 3 year old thread!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 4, 2012 at 8:10 am
Ha Good idea, makes it hard to reply to it. Luckily I still had alerts on this one heh :P.
Yeeh for SSC Alerts :D.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply