Tag Archives: sql server

Configuring Windows Server 2008 R2 Features

Posted on August 10, 2012 by

At Basefarm we frequently need to ensure that many Windows servers are identical in terms of the roles and features they have installed. Adding features can be done in a number of ways. Mostly the graphical userinterface (Server Manager) is … Continue reading →

Posted in Data center | Tagged , , , , , | 1 Comment

SQL Server setup fails due to partitioned network warnings from cluster service

Posted on April 18, 2012 by

I was building a new SQL Server 2008 R2 failover cluster recently and encountered a problem that I hadn’t seen before (which is rare as I’ve seen A LOT of cluster setup problems in my time!). This time it was … Continue reading →

Posted in Troubleshooting, Uncategorized | Tagged , , | 2 Comments

Tracing select statements on specific objects in SQL Server without using Profiler

Posted on February 13, 2012 by

A developer of an application asked me an interesting question the other day. He wanted to know (for reasons not worth going into here) whether his application issued select statements against a specific table in his database. This database was … Continue reading →

Posted in Troubleshooting | Tagged , | Leave a comment

SQL Server 2008 R2 setup fails due to invalid credentials

Posted on September 15, 2011 by

A colleague was trying to install a SQL Server 2008 R2 standalone instance today and he kept hitting a weird error when passing the credentials for the service accounts. He was running the setup as a local administrator on the … Continue reading →

Posted in Troubleshooting | Tagged , , | 6 Comments

SQL Server 2000 cannot start after windows update reboot

Posted on September 13, 2011 by

Last night we had an incident with one of our customers’  old SQL Server 2000 instances. The machine in question had had it’s WSUS windows update run last night and had been forced to reboot after this had occurred. After … Continue reading →

Posted in Troubleshooting | Tagged , , | Leave a comment

SQL Server TSM Restore appears to hang or takes much longer than expected

Posted on June 7, 2011 by

I’ve written previously about the dangers of VLF fragmentation, but the problems I’ve actually experienced before were always related to log based operations, i.e. recovery phase after a crash or database mirroring, but last week I saw an alternate issue … Continue reading →

Posted in Troubleshooting | Tagged , , | Leave a comment

SQL Server deadlocked schedulers leads to unexpected cluster failover–Part 2

Posted on May 6, 2011 by

In Part 1, I looked at how one could identify that a large blocking chain was causing resource exhaustion in SQL Server leading to a cluster failover. Being as we were working retrospectively, we were lacking data to analyse what … Continue reading →

Posted in Troubleshooting | Tagged , , , | 2 Comments

SQL Server deadlocked schedulers leads to unexpected cluster failover–Part 1

Posted on April 29, 2011 by

Here at Basefarm we offer a number of different levels of SLA and support, which can be tailored to customers’ individual needs. One of the highest levels that we offer is called Basefarm Application Management. At this level we take … Continue reading →

Posted in Troubleshooting | Tagged , , , , | 1 Comment

SQL Server 2008 crash: ex_terminator – Last chance exception handling

Posted on April 28, 2011 by

Here at Basefarm we run a large number of 24×7 business critical systems for our customers. So when one of our windows customers recently encountered an unexplained SQL Server crash on one such system, it was something that got our … Continue reading →

Related Posts Plugin for WordPress, Blogger...
Posted in Troubleshooting | Tagged , , | Leave a comment