Extreme-Advice : Analyze IO disk pressure in SQL Server

Before we move further, have a look at my following article as we are going to use the script given in that article:

Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server

I have already provided the script to display Disk IO waits in above given article, now we will further enhance that process.

By looking at IO Stall given in above article, can’t help us much. We should have data captured for few hours or may be a few days so that we can have details like which time/day we get high number of stall, we can find pattern of IO based on the statistics we capture for few hours/days. Now question comes into the picture, how can we do it with help of script given in “Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server” article?

Well we have to enhance the script give there. Let us start our journey to capture pattern of IO.

Click here to read complete article.

Extreme-Advice: Setup development environment for Windows Azure

After explaining what is cloud computing? and essential part of Windows Azure in last few days, many people asked me how they can setup development environment for Windows Azure and how they can test or deploy the application they have created. I got overwhelming response, in form of messages, from the Facebook page of “Extreme-Advice” after keeping above two cloud articles there.

Well, there are many different tools and kits provided by Microsoft to setup your development environment for Windows Azure. Some of the tools are coming in one bundle at the same time you can install it individually as per your requirement. Most of the tools given here, would comes under one bundle itself, now a days , even I have mentioned few of the important part separately just to demonstrate which exact tools comes in use for which purpose.

Here, I will be providing with few of the mandatory tools which you will need to develop Windows Azure application.

Click here to read complete article.

Understanding Microsoft Cloud and its essential part

After giving brief introduction of Cloud few days back I thought to give some light on more details of Microsoft Windows Azure.  Microsoft Windows Cloud is created by so many different services and out of which, following are the some of the important services which makes Windows Cloud more fascinating.

 

Read full article, click here.

Book Review – SQL Server Interview Questions and Answers

Well, I am not as qualified in SQL Server as the authors ofthis book (Pinal Dave & Vinod Kumar) though I dare to writemy review for his book as both of the authors are in my favourite list and I don’teven miss any article written by them then how could I miss a book written bythem? After reading the book, I really tempted to share my personal opinion with my blog reader.
“SQL Server Interview Questions and Answer” makes firstimpression that this book is written to prepare you for the interview of DBA orSQL Developer or BI professional but NO, this book is not ONLY for those whoare preparing for an interview, even seasoned developer or DBA could refer thisbook to master the basics which we may avoid or forget over the time butknowing those may create a firm ground for the project we all are working on.
Both of these authors are well known to present hard &difficult concept in very simple yet powerful manner which directly executeINSERT command in your memory without any trigger or exception, just like straitthrown dart pinch in board, this really show very hard work of both authors.
I really impressed with the book for following points.
  • “Points to Ponder” section at the end of each chapter as a Quick references to Joes 2 Pros books (I had privilege to read few of them)
  • Very inspiring quote at the begging of chapters (I enjoy it in Vinod Kumar’s twits too, in twitter)
  • Links to SQLAuthorty’s articles
When I first heard about this book, I though how much morecontent could be there in this book? As Pinal has already written the seriesarticles on this topic but with my surprise, there are LOT MORE to learn inbook so even if you have read all articles on this series in Pinal’s blog, don’thesitate to have this book, you will have so many (80%) new stuffs to look at.
This book scores 10/10 and I personally highly recommend thisbook as a good & quick reference to any professional who are dealing withSQL Server at any level.
To order the copy of the book for your own, visit SQLAuthority.com
Happy Reading!!!
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile

Last chance to win free Apple iPad this year

SQL Server MVP/Auther/Trainer Jacob Sebastian haslaunched another quiz “SQLServer DBA Quiz 2011” which is the last quiz of this year. So don’t missthis chance and answer the quiz question asked by Quiz master.
My question is already published regarding DeadLock, Live Lock and Blocking. If you have not participated yet, still, youhave chance to win as all questions are still open. 
If you are not seasoned DBA, still you can refer allquestions and answer given by expert to enhance your knowledge.
If you are experienced DBA and you know the answer, you cananswer the question, share you knowledge with community and have chance to winiPad. So what are you waiting for? Try to answer as more question as possible.
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile

Get your server hardware information via DM_OS_SYS_INFO in SQL Server 2005/2008/Denali

DMV(Dynamic Management View) is very powerful tool given my Microsoft in SQLServer 2005+ version; you can get much crucial information from it. Today I amgoing to show you “sys.dm_os_sys_info” which will reveal some of the hardwareinformation of the server which you are using for your SQL Server instance. 
SELECT
      cpu_count asTotal_Logical_CPU_In_Server
      ,HyperThread_Ratio
      ,cpu_count/HyperThread_Ratio asphysical_CPU_In_Server
      –converting bytes of physical memoryto MB
      ,(physical_memory_in_bytes/1024)/1024 as Total_Memory_Of_Server_In_MB
      ,(Virtual_memory_in_bytes/1024)/1024 as Current_Usage_Of_Memory_SQLServer_In_MB
      –following fields will work only inSQL Server 2008+
      –if you are using SQL Server 2005,comment following field.
      ,sqlserver_start_time
     
FROM
      sys.dm_os_sys_info
Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile

Take mirror backup of database in SQL Server 2005/2008/Denali

Backup is one of the most important tasks of DBA. Withouthaving proper backup, you are running in danger mode always so it is good tokeep more than backup file with you always so in any emergency if one backupgets corrupt or missing, you can use other one.
In early days of SQL Server, especially before SQL Server2005, DBA used to take full backup of database and copy it somewhere else viaDOS command XCOPY to make another copy of the same to other disk drive orsomewhere in network but SQL Server 2005+ provides the facility to take backupwith mirror copy so you don’t need to put additional efforts to make copy ofyour database backup and move it somewhere else.
Suppose my database name “SQLHub” so I would use following commandto take copy of that database in D drive and mirror copy in E drive.
–database backup of SQLHub
–full back in Ddrive SQLHubBackup folder
–same backupcopy will be copied at E drive SQLHubBackup folder
BACKUP DATABASE SQLHub
      TO DISK= ‘D:\SQLHubBackup\SQLHub.bak’
MIRROR
      TO DISK= ‘E:\SQLHubBackup\SQLHub.bak’
WITH FORMAT
GO
“With Format” option in backup is not mandatory. If we takebackup of database with backup file name SQLHub.bak on 8th July 2011,when we again run the same database backup with same backup file name “SQLHub.bak”on 9th July 2011, SQL Server keeps previous backup of database inSQLHub.bak file and copy the next so your both backup taken on 8thand 9th july 2011 will now be there in SQLHub.bak file, if you have NOT used “WITH FORMAT” option. 
If you want to take backup on 9th July 2011 and wantto remove database back taken on 8th July 2011, which is there withthe same backup file name “SQLHub.bak”, you have to use “WITH FORMAT” clause.
Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile