I’ve come across this error message quite a few times. Last weekend, it was when I had to dig deeper due to repetitive alerts. Apparently, I couldn’t find any article on this error message, hence this blog.
Error Message
Error: 7886, Severity: 20, State: 1
A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection willbe terminated.
Below are my observations/research on this error message which also includes my leanings on working on similar cases while I was at Microsoft.
Read the rest of this entry »
Hi all,
I am back again with another interesting issue.
We had a situation last week where we had to un-install a service pack from one of our production environment as a part of change back out plan.
Though the plan looks very simple as MS has provided a very good functionality of removing it from add and remove programs.
Just go to add and remove programs, select check box “show updates” or got to “installed an update” select the service pack which you want to remove and we are done!!
Read the rest of this entry »
Alright! So till now we have created 1 DC , 1 domain “Manishlab” and then added 2 nodes (NODE1, NODE2) in to the domain. Now we have reached to the last and final segment of this series. In this final post of the series we will do following things.
- Configure an iSCSI target to create a shared disk.
- Add this target as Shared disk to both the nodes.
- Enable Failover Cluster feature
- Create Failover Cluster, add shared disk in to the cluster.
Note: We will not install SQL Server in this series as I am assuming we know how to install SQL Server on a failover cluster once we have all the pre-requisite available.
Read the rest of this entry »
Ok! Now we have our 3 VM’s Machine ready to ROCK… 
So lets proceed with the next step.
As stated in last post, we will learn following things in this part.
- Create a domain controller (To know more about DC read this technet)
- Create a Domain
- Assign an static IP to your “Domain Controller”
- Enable and configure DHCP Server
Read the rest of this entry »
Hi all,
Hope you all are doing good, its been long time since i have written some thing so today i decided to start again and this time its going to be a series
Imagine you want to give a demo which requires SQL Server failover cluster but you do not have a environment to show that, but how good it be if we can achieve this with a single machine itself without buying expensive hardware or extra machines.. isn’t it cool??
Hyper-v is one great role/feature available which can help us in achieving this. You can read more about Hyper-V in this technet .
This is an effort to start series of blog on hyper-v, in this blog we will create our own lab with 1 domain controller and 2 nodes to work as failover cluster. If you want to create 1 single machine as VM you can follow this well documented blog as well.
We will divide this series in 3 parts as follows.
[Part -1]
- What is hyper-v and benefits of hyper -v
- Requirement for hyper-v on Winodws 8/Windows Server 2008 to create SQL Server Failover cluster
- Prepare VM’s for SQL Server failover cluster
- Create 1 Virtual Machine which will act as domain controller
- Create 2nd Virtual Machine as Node 1
- Create 3rd Virtual Machine as Node 2
Read the rest of this entry »
Hey, I seldom see these messages in ERROLROG, is this something I should be concerned about?
[WARNING] 2013-02-14 05:25:15.97 spid61 Timeout occurred while waiting for latch: class ‘DATABASE_CHECKPOINT’, id 0000000017560830, type 4, Task 0x000000000043EBC8 : 0, waittime 300, flags 0x1a, owning task 0x00000000009F0508. Continuing to wait.
The short answer is – No. This ‘particular’ message is not to be concerned about for the period it occurred on this server.
Why do I say that? Want to know more. Then go ahead and read the longer version.
Read the rest of this entry »
I recently worked on an issue where SQL Server was experiencing memory pressure. During the troubleshooting, one of my colleagues asked an interesting question as how Stolen Potential is calculated and why is stolen potential negative? I thought to share what I researched and learned through a quick blog post.
In SQL Server 2008, when SQL Server experiences memory pressure (usually due to Buffer pool pressure on x64 instance) the following error is logged in ERRORLOG:
2012-10-30 15:50:42.21 spid67 Error: 701, Severity: 17, State: 123.
2012-10-30 15:50:42.21 spid67 There is insufficient system memory in resource pool 'default' to run this query.
Read the rest of this entry »
CK
Manish Upadhyay
Prashant Kumar
