Solved

do some errors more prone to SQL server on VMs?

Posted on 2014-07-22
5
373 Views
Last Modified: 2014-07-31
From your experience, have you seen some errors repeat more so in the virtual environment more than
 SQL servers hosted in physical boxes?
0
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 5

Author Comment

by:25112
ID: 40212549
for example, when we run the below, we get them only in the boxes that are virtual.. we have not seen this error in any of the physical servers so far:


EXEC master.dbo.xp_readerrorlog 0, 1, 'Error: 823'  
EXEC master.dbo.xp_readerrorlog 1, 1, 'Error: 823'
EXEC master.dbo.xp_readerrorlog 2, 1, 'Error: 823'
EXEC master.dbo.xp_readerrorlog 3, 1, 'Error: 823'
EXEC master.dbo.xp_readerrorlog 4, 1, 'Error: 823'
EXEC master.dbo.xp_readerrorlog 5, 1, 'Error: 823'
EXEC master.dbo.xp_readerrorlog 6, 1, 'Error: 823'
 
EXEC master.dbo.xp_readerrorlog 0, 1, 'Error: 824'  
EXEC master.dbo.xp_readerrorlog 1, 1, 'Error: 824'
EXEC master.dbo.xp_readerrorlog 2, 1, 'Error: 824'
EXEC master.dbo.xp_readerrorlog 3, 1, 'Error: 824'
EXEC master.dbo.xp_readerrorlog 4, 1, 'Error: 824'
EXEC master.dbo.xp_readerrorlog 5, 1, 'Error: 824'
EXEC master.dbo.xp_readerrorlog 6, 1, 'Error: 824'
 
 could you try this in your VM box vs physical box in non-peak hours to confirm/check/infer?
0
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 125 total points
ID: 40213581
I have tried this on both a physical server, and a vm - both work correctly.

Please note the following change

EXEC master.dbo.xp_readerrorlog 0, 1, N'Error: 823'  

Without the N (for nvarchar) it would not work in either.

Kelvin
0
 
LVL 5

Author Comment

by:25112
ID: 40214323
Kelvin

>>I have tried this on both a physical server, and a vm - both work correctly.
you mean you got zero entries back.. meaning no such errors at all? was it 2008?

>>Without the N (for nvarchar) it would not work in either.
It brings back records for me? I thought it won't work only if there are Unicode characters inside the quotes?
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 375 total points
ID: 40227436
Any occurrence of those errors is a major concern, regardless of whether it's on a physical or virtual server. Both of those errors (823 and 824) are serious file consistency errors that indicate a massive concern at the storage layer (or at the OS layer as it communicates with storage). I'd immediately raise the issue with your OS and Storage Administrators (if that's not also you) to try and find the cause.

That said, there's nothing about a VM that would cause issues of any kind to occur more frequently than on a physical server - it should be transparent to the virtualized OS and applications, so they should be unaware of whether the host is physical or virtual. That said, virtualized environments have an additional layer of abstraction between the application and the hardware - instead of app -> OS -> hardware, it's app -> OS -> hypervisor -> hardware, which is an additional place that problems can arise. It will tend to exacerbate any latency or resource crowding issues you're already experiencing, so VMs tend to expose issues that already exist.

For these errors in particular, it's an indication that the VM can't save reliably to the shared storage. Since you don't see the issue on your physical servers, what's different about the VMs that would cause these storage issues to manifest? Some questions to ask:

 - Are other VMs on the server experiencing slow storage access times, or just the SQL Servers?
 - Are you using iSCSI or Fiber for your storage? iSCSI can be impaired by other network bandwidth issues, so check your switches - Fiber switches can also get crowded and lead to impairments, but they're significantly faster and tend to be dedicated to storage, but something to check.
 - Are all the VMs hosted by a single virtual host machine? If so, is there an issue with the HBA or storage access in that server?
 - Is the host machine(s) under these VMs crowded for resources, meaning the VMs can't get the resources they need in an acceptable amount of time?

I'd check the performance and resource load of the host underneath these VMs to see if it looks like there's a problem there. Though it could be related to the actual storage as well, but since you're only seeing it on the VMs and not the physical SQL Servers, I'd expect it's an issue present on the physical VM host machines rather than at the storage layer.
0
 
LVL 5

Author Comment

by:25112
ID: 40231775
thank u for the detailed response and help-guidance!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question