SQL Server Denali – AlwaysON (HADR): Step-by-Setup setup guide

  You may have seen the announcement of release SQL Server Code-Named “Denali” in recent PASS summit (featured in Ted Kummert’s keynote). Even morem “Denali” Community Technology Preview 1 (CTP1) is available for download here  “Denali” release have several new and improved components listed here. Being a SQL Engine guy, I particularly got excited with…

0

Microsoft Codename Atlanta::How to get in there….

  To begin with, lets first get the basics: What is Atlanta? Microsoft Codename Atlanta (http://beta.microsoftatlanta.com) is an online service that analyzes installations of Microsoft SQL Server 2008 (and later versions) and provides proactive alerts to help you avoid system downtime and follow best practices with regard to configuration and usage. Do I (you) need…

6

Create a SQL Server Database on a network shared drive

  Hello All, Sometime back, I have written blog post on ‘Backing-up SQL Server Database on a network shared drive’. This can be found here. I have received numerous queries on an another related topic i.e. ‘How to Create a SQL Server Database on a network shared drive’. It took sometime (a brand new SQL…

3

TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths

  Hi Guys In a recent issue with a customer, I came across a strange SQL belief (or say a DBA Myth) around SQL Server Transaction Logs Backup/Restore. Let me explain you what was the scenario and then let’s try attempting to break the myth with real testing. SCENERIO: -    Customer is taking FULL and…

2

SQL Server – Missing Performance Counters: A consolidated list of known issues

Technorati Tags: Performance Counter Missing SQL Server performance counters missing!! Past few hours been crazy one, breaking my head on a ‘Missing Performance Counters’ and now since this is resolved, I want to now off-load every bit of this issue from my brain so thought blogging it 🙂 Issue: A customer is having 24×7 PERFMON…

1

DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]

Here’s an interesting issue that surfaced recently while troubleshooting a database performance slowness issue. Here, we were trying tune the performance of database for SCOM (System Center Operations Manager). While, we started with regular tuning stuff, finally found something interesting and was a learning for me. I blogged this here. Hope you’ll enjoying learning along with me 🙂…

0

SQL Server 2008 RTM Support Ends April 13, 2010. Time for SP1

SQL Server 2008 RTM finally reaches it’s end of support tomorrow i.e. April 13, 2010. Here’s snippet from SQL Release Services team blog: Product: SQL Server 2008 RTM Mainstream Support End Date: 4/13/2010 Extended Support End Date: Not Applicable    Options / Notes:  Technical support ends as of 04/13/2010; options for technical and/or hotfix support after…

0

INF: A missing exception handler can cause blocking and eventual application hang.

Recently, while working on a SQL Performance issue, I encountered a blocking scenario, causing the query timeout and application hang. I worked on this issue along with my colleague Suhas. We started with some vanilla testing and eventually were able to re-produce the issue. Read my latest post on SQLServerFAQ to figure out how can…

0