Unsolved
This post is more than 5 years old
2 Intern
•
294 Posts
0
29434
February 13th, 2012 06:00
SQL Server 2008 R2 - Lost Volume Due To I/O Bottleneck
Hi,
Over the weekend, I was updating statistics on SQL Server and the table happened to be fairly large (66.2 GB Data and 4.8 GB Index). All of sudden, the tempDB volume disappeared which caused chaos for SQL Server.
In the SQL Server logs, there were three entries stating "SQL Server has encountered 2200 occurrences of I/O requests taking longer than 15 seconds to complete on file ."
Shortly after, SQL Server logs had numerous entries stating "BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds" and "120 seconds".
Then the volume disappeared because SQL Server was shooting messages stating that the tempDB files cannot be reached and SQL Server and SQL Agent services went down.
The volume has more than enough space on it for tempDB to grow automatically.
I'm wondering why the volume just went down due to an I/O bottleneck. What can I do from the SAN standpoint to remedy this (as this is a SAN problem)?
Thank you.
dajonx
2 Intern
•
294 Posts
0
February 13th, 2012 06:00
Good morning Don,
The firmware is 5.1.2. The Dell switches are two 6224's stacked. We have two arrays (PS6000E and PS6000VX) and we have tempDB residing on the PS6000VX (RAID 10).
dajonx
2 Intern
•
294 Posts
0
February 13th, 2012 07:00
I will verify the configs of the switches and am planning on upgrading the firmware to 5.2.1 soon. How does this alleviate the I/O bottleneck as seen in the logs as "I/O requests taking longer than 15 seconds"?
dajonx
2 Intern
•
294 Posts
0
February 13th, 2012 10:00
Ok thank you. I'll open a support case.
Joe S586
9 Technologist
•
729 Posts
0
February 13th, 2012 10:00
If you are clicking “customer support” from within the Group Administrator GUI “Tools” menu, then you may not have a management network setup, and/or the array doesn’t have access the internet (since the link is to a URL outside of the SAN network).
To contact support either do one of the following, login to the support site, or call them directly.
To login to the support site, please use this URL: support.equallogic.com (valid support usename and pw required).
The phone number for support is on the same page.
-joe
dajonx
2 Intern
•
294 Posts
0
February 13th, 2012 10:00
I am receiving an internal server error when trying to open a case...
dajonx
2 Intern
•
294 Posts
0
February 13th, 2012 10:00
I have logged in to the support.equallogic.com and clicked on Log A Case. I then filled out the necessary information and clicked on Submit Case. I still receive the message "The page cannot be displayed because an internal server error has occurred."