Monitoring & Setting Alerts for SQL Server Critical Errors

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 20-01-2011

10

As a Proactive DBA, you must monitor All SQL Server errors having severity level between 17 to 25. Any errors from level 20 to 25 are serious in nature however for 17 to 19 a DBA involvement is required for resolution. Here is self explanatory MS description of error levels, steps to get automatic alert as soon as any of error occurs and list of error messages.

Automate SQL Server Profiler Trace Execution

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 12-01-2011

0

SQL profiler is an excellent tool for T-SQL query performance optimization. SQL Server Production DBA’s use Profiler to scan what T-SQL queries are getting executed inside SQL Server and what are the queries that can be filtered for further fine-tuning. SQL profiler has inbuilt scheduler for stopping a trace, but Trace Properties does not provide functionality to automatically schedule a trace and keep it running for a desired frequency.

What Lenovo IdeaPad Y560 Laptop Can’t do?

Posted by Deepak Kumar | Posted in SQL DBA, Uncategorized | Posted on 03-01-2011

2

I rarely find time to play computer games, however when I do, I certainly go for Need for Speed racing game from EA. Considering high system requirements for now a days demanding games and with prime reason to run multiple virtual machines for SQL testing, I decided to go for Lenovo laptop for the second time. It was hard to choose but I was somehow confident with what I have chosen. Lenovo IdeaPad Y560 06465BU is a pretty decent size hardware to do most of stuff, Under the hood It has:

This Year, I will..

Posted by Deepak Kumar | Posted in SQL DBA, Uncategorized | Posted on 02-01-2011

1

As the new year begins.. What is your New Year resolution for fresh start? quit smoking or drinking? Or hit gym more often, lose weight and get back in shape? Find a new job? Save more money or get out of debt?

In addition to these, If you have space left for something called “learn something new!” here is what I can offer for free that I enjoy following and practicing. These are set of rules that you can pursue for better results and overall improvements.

image

Survival the fittest – if you cannot adopt changing technology, work culture, requirements, life style or surroundings you will move out of race pretty soon. Its mantra of life; stay flexible and be ready to accept changes, mold yourself, swim with the flow, absorb what you get; if you can not get dissolved in progression, will be filtered out. This is the phrase that evolved life & diversity on planet earth.

No pain, no gain – it’s simple motivational theory, like 1+1; there are no free lunches in this world. If you need something you got to do something in return. Stand up; get ready to pay in advance for what you desire. There are no magical Ginny in this world. Always remember Pain is momentary, but Glory is for forever!

Never, ever, repeat mistakes - If you keep on making same mistakes you never going to move out of circular drive & better you forget designation. Remember it always, if you cannot; it’s the one you can have tattoo on. Making mistakes are not exactly bad, but at the end you should learn from your mistakes and making sure you never repeat & forget learning.

Go get it, no reservations needed! – Nobody come to your door with a free lottery ticket to win, come on. You want something? You better get going, if not now; then when? Do not just keep on waiting for favorable conditions; instead achieve your targets and move ahead for next one.

Everyone and everything can teach you something – Ask yourself, have your learned everything? No, never you can’t simply.. There is so much you still have to do & explore. In plain words, stay hungry & open to learn more.

Welcome 2011

Posted by Hemantgiri S. Goswami | Posted in Uncategorized | Posted on 31-12-2010

1

Greetings!!!

Myself Hemantgiri S. Goswami, SQL Server MVP, I am extremely happy to join SQL Knowledge as an author again. In coming days I will be actively sharing an articles, scripts and tips here.

I would like to thank Deepak for inviting me to be a part of SQL Knowledge once again.

2011

How to Monitor SQL Server CPU Usage and get auto alerts

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 28-12-2010

26

There are some condition & times when SQL Server CPU utilization exceeds threshold value (ex 80% or more) and stay constant even till 100% for a undefined duration. A DBA do not get notified automatically about performance degrade until its reported by application team or service desk . This usually happens when all in sudden unpredicted application workload goes to SQL Server for processing; but at good number of times, its because of some T-SQL Queries are taking longer than expected or because of bad execution plan or blocking. There may be more reason to add, but ultimately high CPU utilization on production systems is going to hurt performance.

SQL Server Query for Capacity Planning – SQL 2005 & 2008

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 26-12-2010

14

As a proactive DBA its one of responsibility to keep an eye on database’s growth and other file system changes for the databases hosted on SQL instance. However being busy on daily DBA tasks, its not always possible to prepare scripts or manually extract data from system for documentations & trend reporting purposes. I faced the similar challenge while working with large DB systems and came up with a T-SQL script that can do the needful without worries..

Wish you a Merry Christmas

Posted by Deepak Kumar | Posted in SQL DBA | Posted on 25-12-2010

0

From SQLknowledge and Team, We wish you and your family a Merry Christmas! It was big fun on Christmas eve, we went to see a 90ft Christmas tree and gifts shopping.

IMG_0403

Happy to join SQLKnowledge

Posted by Shashikant | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 25-12-2010

1

I have joined sqlknowledge and in addition to Deepak and other members, I will be writing about SQL troubleshooting, tips and tricks keep checking for more..

Merry Christmas

SQL 2011 Denali Basic Setup and Configurations

Posted by Deepak Kumar | Posted in SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 22-12-2010

0

In continuation of my earlier post for Denali CTP1 launch, here are SQL Server 2011 setup screen prints. To begin with you can download installation media from Microsoft Link. Before you start installation, you must check system requirement and are as follows:

System Requirements: Details

  • Supported Operating Systems:Windows 7;Windows Server 2008 R2;Windows Server 2008 Service Pack 2;Windows Vista Service Pack 2
  • 32-bit systems
  • Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
  • 64-bit systems
  • 1.4 GHz or faster processor
  • Minimum of 1 GB of RAM (2 GB or more is recommended.)
  • 2.2 GB of available hard disk space

The very first screen you will see is typical SQL Server installation, For this installation I used new SQL Server stand alone installation.

clip_image002

clip_image004

clip_image006

clip_image008

clip_image010

clip_image012

clip_image014

clip_image016

clip_image018

clip_image020

clip_image022

clip_image024

clip_image026

clip_image028

clip_image030

clip_image032

clip_image034

clip_image036 

 

clip_image038

clip_image040

© 2010 SQLKnowledge.com Increase your website traffic with Attracta.com