Skip to main content


Showing posts from April, 2012

Performance Dashboard

SQL Server 2008 provide graphical reports for monitoring system health and performance. While there have always been various queries, stored procedures,  Dynamic Management Views, to gather system statistics, none were graphical. These new reports provide a quick easy way to print off a professional looking report for presentations or discussions.  This is an additional add-on feature of  SQL Server Management Studio which is also known as Performance Dashboard . We Can Start Report from Below : When select Stand Reports, below built in reports will be displayed. Disk Usage by Top Tables Disk Usage by Table Disk Usage by Partition Backup and Restore Events All Transactions All Blocking Transactions Top Transactions by Age Top Transactions by Blocked Transactions Count Top Transactions by Locks Count Resource Locking Statistics by Objects Object Execute Statistics Database Consistency history Inde

3 Easy Steps to Configure Database Mail

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine.  I am going to use Database Mail to Configure Automation Failure Notification.. Create an e-mail profile, specify its SMTP accounts and  Specify profile security. Configure Operator. Assign Operator on Jobs/Schedulers. In First Step: Create an e-mail profile, specify its SMTP accounts. To Varify check TSQL   use msdb SELECT *   FROM [msdb] . [dbo] . [sysmail_profile] Now Enable Database Mail service. USE master Go EXEC sp_configure 'show advanced options' , 1 Go RECONFIGURE Go EXEC sp_configure 'Database Mail XPs' , 1 Go RECONFIGURE Go EXEC sp_configure 'show advanced options' , 0 Go RECONFIGURE Go In 2nd Step : Configure Operator. To Varify TSQL   use msdb SELECT *    FROM [msdb] . [dbo] . [sysoper

Searching Hard Coded Values

Searching Hard Coded Values from Entire Database-Objects is very Interesting Task for me. My last Blog ( Search Dynamic Values ) was for Dynamic Values from Tables . Today I want to show how I am searching Hard Coded values (E-mail Ids and Mobile numbers) from all  Procedures  or  Views  from our Database.We should avoid the Hard codes in objects. To manages Hard codes in objects  i was simply Converting all procedures and Views in script and after that using find -replace i was managing changes...It was very time consuming and bothering work form me... Below Query help and save my lot of time for learning extras..... declare @text varchar ( 100 ) declare @dbname varchar ( 100 )        set @text = 'sumank'   set @dbname = 'masterdatabase' if @dbname is null begin --enumerate all databases. DECLARE #db CURSOR FOR Select Name from master .. sysdatabases declare @c_dbname varchar ( 64 )    OPEN #db FETCH #d