Solved

do some errors more prone to SQL server on VMs?

Posted on 2014-07-22
5
370 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

770 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