0% found this document useful (0 votes)

6 views21 pages

SQL Server Health Check Report

The document outlines a SQL Server health check procedure that generates an HTML report detailing various server metrics such as CPU usage, memory usage, disk space, database connections, and backup status. It includes the creation of temporary tables to store data on server performance, blocking processes, and error logs, and it also prepares the data for email delivery. The procedure is designed to help monitor and maintain the health of SQL Server instances.

Uploaded by

vishwashc123

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

6 views21 pages

SQL Server Health Check Report

Uploaded by

vishwashc123

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

/****************************************************************************/

-- Report Type: HTML Report Delivers to Output Window / Mailbox

-- Parameters: DBMail Profile Name *, Email ID *, Server Name (Optional);
---- Server Details
---- Instance Information
---- Disk Space Usage
---- Tempdb Usage
---- CPU Usage
---- Memory Usage
---- Performance Counter Data
---- Missing Backup Report
---- Database Connections
---- Database Log Space Usage
---- SQL Agent Job Status
---- Blocking Process Information
---- Long Running Transactions
---- Top 20 Table Size
---- Index Analysis
---- SQL ErrorLog
/****************************************************************************/
/****************************************************************************/

IF EXISTS ( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].

[usp_SQLhealthcheck_report_basic]') AND [TYPE] = 'P')
BEGIN
DROP PROCEDURE [dbo].[usp_SQLhealthcheck_report_basic];
END
GO
CREATE PROCEDURE [dbo].[usp_SQLhealthcheck_report_basic](
@MailProfile NVARCHAR(200) = NULL,
@MailID NVARCHAR(2000) = NULL,
@Server VARCHAR(100) = NULL)
WITH ENCRYPTION
AS
BEGIN
SET NOCOUNT ON;
SET ARITHABORT ON;

DECLARE @ServerName VARCHAR(100);

SET @ServerName = ISNULL(@Server,@@SERVERNAME);

/*************************************************************/
/****************** Server Reboot Details ********************/
/*************************************************************/

CREATE TABLE #RebootDetails

(
LastRecycle datetime,
CurrentDate datetime,
UpTimeInDays varchar(100)
)
Insert into #RebootDetails
SELECT sqlserver_start_time 'Last Recycle',GetDate() 'Current Date', DATEDIFF(DD,
sqlserver_start_time,GETDATE())'Up Time in Days'
FROM sys.dm_os_sys_info;

CREATE TABLE #DBStatus

(
name VARCHAR(100),
state VARCHAR(10),
state_desc varchar(100)
)
Insert into #DBStatus
SELECT name,state,state_desc from [Link] where state != 0;

/*************************************************************/
/****************** Current Blocking Details *****************/
/*************************************************************/
CREATE TABLE #BlkProcesses
(
spid varchar(5),
Blkspid varchar(5),
PrgName varchar(100),
LoginName varchar(100),
ObjName varchar(100),
Query varchar(255)
)
insert into #BlkProcesses
SELECT [Link], BlockingSPID = [Link], substring(s.program_name,1,99),
SUBSTRING([Link],1,99),
ObjectName = substring( OBJECT_NAME(objectid, [Link]),1,99), Definition =
CAST(text AS VARCHAR(255))
FROM [Link] s
CROSS APPLY sys.dm_exec_sql_text (sql_handle)
WHERE [Link] > 50 AND [Link] > 0

/*************************************************************/
/****************** Errors audit for last 4 Days *************/
/*************************************************************/

CREATE TABLE #ErrorLogInfo_all

(
LogDate datetime,
processinfo varchar(200),
LogInfo varchar(1000)
)

CREATE TABLE #ErrorLogInfo

(
ID INT IDENTITY PRIMARY KEY NOT NULL,
LogDate varchar(100),
LogInfo varchar(2000)
)

DECLARE @A VARCHAR(10), @B VARCHAR(10);

SELECT @A = CONVERT(VARCHAR(20),GETDATE()-1,112);
SELECT @B = CONVERT(VARCHAR(20),GETDATE()+1,112);
INSERT INTO #ErrorLogInfo_all
EXEC XP_READERRORLOG 0, 1,N'Login', N'Failed', @A,@B,'DESC';

INSERT INTO #ErrorLogInfo (LogDate,LogInfo)

select DISTINCT CONVERT(VARCHAR(20),GETDATE()+1,111) "LogDate",LogInfo from
#ErrorLogInfo_all;

/***********************************************************/
/************* Windows Disk Space Details ******************/
/***********************************************************/

CREATE TABLE #FreeSpace (DName CHAR(1), Free_MB BIGINT, Free_GB DECIMAL(16,2))

INSERT INTO #FreeSpace (DName,Free_MB) EXEC XP_FIXEDDRIVES;
UPDATE #FreeSpace SET Free_GB = CAST(Free_MB / 1024.00 AS DECIMAL(16,2));

/*************************************************************/
/************* SQL Server CPU Usage Details ******************/
/*************************************************************/
Create table #CPU(
servername varchar(100),
EventTime2 datetime,
SQLProcessUtilization varchar(50),
SystemIdle varchar(50),
OtherProcessUtilization varchar(50),
load_date datetime
)
DECLARE @ts BIGINT; DECLARE @lastNmin TINYINT;
SET @lastNmin = 240;
SELECT @ts =(SELECT cpu_ticks/(cpu_ticks/ms_ticks) FROM sys.dm_os_sys_info);
insert into #CPU
SELECT TOP 10 * FROM (
SELECT TOP(@lastNmin)
@ServerName AS 'ServerName',
DATEADD(ms,-1 *(@ts - [timestamp]),GETDATE())AS [Event_Time],
SQLProcessUtilization AS [SQLServer_CPU_Utilization],
SystemIdle AS [System_Idle_Process],
100 - SystemIdle - SQLProcessUtilization AS [Other_Process_CPU_Utilization],
GETDATE() AS 'LoadDate'
FROM (SELECT [Link]('(./Record/@id)[1]','int')AS record_id,
[Link]('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]','int')AS
[SystemIdle],
[Link]('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)
[1]','int')AS [SQLProcessUtilization],
[timestamp]
FROM (SELECT[timestamp], convert(xml, record) AS [record]
FROM sys.dm_os_ring_buffers
WHERE ring_buffer_type =N'RING_BUFFER_SCHEDULER_MONITOR'AND record LIKE'%%')AS
x )AS y
ORDER BY SystemIdle ASC) d

/*************************************************************/
/************* SQL Server Memory Usage Details ***************/
/*************************************************************/

CREATE TABLE #Memory_BPool (

BPool_Committed_MB VARCHAR(50),
BPool_Commit_Tgt_MB VARCHAR(50),
BPool_Visible_MB VARCHAR(50));

-- SQL server 2008 / 2008 R2

--INSERT INTO #Memory_BPool
--SELECT
-- (bpool_committed*8)/1024.0 as BPool_Committed_MB,
-- (bpool_commit_target*8)/1024.0 as BPool_Commit_Tgt_MB,
-- (bpool_visible*8)/1024.0 as BPool_Visible_MB
--FROM sys.dm_os_sys_info;

---- SQL server 2012 / 2014 / 2016

INSERT INTO #Memory_BPool
SELECT
(committed_kb)/1024.0 as BPool_Committed_MB,
(committed_target_kb)/1024.0 as BPool_Commit_Tgt_MB,
(visible_target_kb)/1024.0 as BPool_Visible_MB
FROM sys.dm_os_sys_info;

CREATE TABLE #Memory_sys (

total_physical_memory_mb VARCHAR(50),
available_physical_memory_mb VARCHAR(50),
total_page_file_mb VARCHAR(50),
available_page_file_mb VARCHAR(50),
Percentage_Used VARCHAR(50),
system_memory_state_desc VARCHAR(50));

INSERT INTO #Memory_sys

select
total_physical_memory_kb/1024 AS total_physical_memory_mb,
available_physical_memory_kb/1024 AS available_physical_memory_mb,
total_page_file_kb/1024 AS total_page_file_mb,
available_page_file_kb/1024 AS available_page_file_mb,
100 - (100 * CAST(available_physical_memory_kb AS
DECIMAL(18,3))/CAST(total_physical_memory_kb AS DECIMAL(18,3)))
AS 'Percentage_Used',
system_memory_state_desc
from sys.dm_os_sys_memory;

CREATE TABLE #Memory_process(

physical_memory_in_use_GB VARCHAR(50),
locked_page_allocations_GB VARCHAR(50),
virtual_address_space_committed_GB VARCHAR(50),
available_commit_limit_GB VARCHAR(50),
page_fault_count VARCHAR(50))

INSERT INTO #Memory_process

select
physical_memory_in_use_kb/1048576.0 AS 'Physical_Memory_In_Use(GB)',
locked_page_allocations_kb/1048576.0 AS 'Locked_Page_Allocations(GB)',
virtual_address_space_committed_kb/1048576.0 AS
'Virtual_Address_Space_Committed(GB)',
available_commit_limit_kb/1048576.0 AS 'Available_Commit_Limit(GB)',
page_fault_count as 'Page_Fault_Count'
from sys.dm_os_process_memory;

CREATE TABLE #Memory(

ID INT IDENTITY NOT NULL,
Parameter VARCHAR(200),
Value VARCHAR(100));

INSERT INTO #Memory

SELECT 'BPool_Committed_MB',BPool_Committed_MB FROM #Memory_BPool
UNION
SELECT 'BPool_Commit_Tgt_MB', BPool_Commit_Tgt_MB FROM #Memory_BPool
UNION
SELECT 'BPool_Visible_MB', BPool_Visible_MB FROM #Memory_BPool
UNION
SELECT 'Total_Physical_Memory_MB',total_physical_memory_mb FROM #Memory_sys
UNION
SELECT 'Available_Physical_Memory_MB',available_physical_memory_mb FROM #Memory_sys
UNION
SELECT 'Percentage_Used',Percentage_Used FROM #Memory_sys
UNION
SELECT 'System_memory_state_desc',system_memory_state_desc FROM #Memory_sys
UNION
SELECT 'Total_page_file_mb',total_page_file_mb FROM #Memory_sys
UNION
SELECT 'Available_page_file_mb',available_page_file_mb FROM #Memory_sys
UNION
SELECT 'Physical_memory_in_use_GB',physical_memory_in_use_GB FROM #Memory_process
UNION
SELECT 'Locked_page_allocations_GB',locked_page_allocations_GB FROM #Memory_process

UNION
SELECT 'Virtual_Address_Space_Committed_GB',virtual_address_space_committed_GB FROM
#Memory_process
UNION
SELECT 'Available_Commit_Limit_GB',available_commit_limit_GB FROM #Memory_process
UNION
SELECT 'Page_Fault_Count',page_fault_count FROM #Memory_process;

/******************************************************************/
/*************** Database Backup Report ***************************/
/******************************************************************/
CREATE TABLE #Backup_Report(
name VARCHAR(300),
last_backup_time VARCHAR(50),
recovery_model_desc VARCHAR(50),
state_desc VARCHAR(50),
backup_type VARCHAR(50),
physical_device_name VARCHAR(300));

WITH CTE_Backup AS
(
SELECT database_name,backup_start_date,type,physical_device_name
,Row_Number() OVER(PARTITION BY database_name,[Link]
ORDER BY backup_start_date DESC) AS RowNum
FROM msdb..backupset BS
JOIN [Link] BMF
ON BS.media_set_id=BMF.media_set_id
)INSERT INTO #Backup_Report
SELECT [Link]
,ISNULL(CONVERT(VARCHAR,backup_start_date),'No backups') AS
last_backup_time
,D.recovery_model_desc
,state_desc,
CASE WHEN type ='D' THEN 'Full database'
WHEN type ='I' THEN 'Differential database'
WHEN type ='L' THEN 'Log'
WHEN type ='F' THEN 'File or filegroup'
WHEN type ='G' THEN 'Differential file'
WHEN type ='P' THEN 'Partial'
WHEN type ='Q' THEN 'Differential partial'
ELSE 'Unknown' END AS backup_type
,physical_device_name
FROM [Link] D
LEFT JOIN CTE_Backup CTE
ON [Link] = CTE.database_name
AND RowNum =1

/*************************************************************/
/****************** Connection Details ***********************/
/*************************************************************/

-- Number of connection on the instance grouped by hostnames

Create table #ConnInfo(
Hostname varchar(100),
NumberOfconn varchar(10)
)
insert into #ConnInfo
SELECT Case when len(hostname)=0 Then 'Internal Process' Else hostname
END,count(*)NumberOfconnections
FROM [Link]
GROUP BY hostname

/*************************************************************/
/************** Currently Running Jobs Info ******************/
/*************************************************************/
Create table #JobInfo(
Server_Name varchar(100),
Step_Name varchar(100),
SQL_Job_Name varchar(100),
RunDateTime varchar(100),
Failure_Date varchar(100),
StepDuration varchar(100),
ExecutionStatus varchar(100),
Error_Message nvarchar(2000)
)
insert into #JobInfo
SELECT DISTINCT [Link] AS [Server_Name],
T1.step_name AS [Step_Name],
SUBSTRING([Link],1,140) AS [SQL_Job_Name],
[Link].agent_datetime(run_date, run_time) as 'RunDateTime',
CAST(CONVERT(DATETIME,CAST(run_date AS CHAR(8)),101) AS CHAR(11)) AS
[Failure_Date],
T1.run_duration StepDuration,
CASE T1.run_status
WHEN 0 THEN 'Failed'
WHEN 1 THEN 'Succeeded'
WHEN 2 THEN 'Retry'
WHEN 3 THEN 'Cancelled'
WHEN 4 THEN 'In Progress'
END AS ExecutionStatus,
[Link] AS [Error_Message]
FROM
msdb..sysjobhistory T1 INNER JOIN msdb..sysjobs T2 ON T1.job_id = T2.job_id
WHERE
T1.run_status NOT IN (1, 4)
AND T1.step_id != 0
AND run_date >= CONVERT(CHAR(8), (SELECT DATEADD (DAY,(-1), GETDATE())), 112)

/*************************************************************/
/****************** Tempdb File Info *************************/
/*************************************************************/
-- tempdb file usage
Create table #tempdbfileusage(
servername varchar(100),
databasename varchar(100),
filename varchar(100),
physicalName varchar(100),
filesizeMB varchar(100),
availableSpaceMB varchar(100),
percentfull varchar(100)
)

DECLARE @TEMPDBSQL NVARCHAR(4000);

SET @TEMPDBSQL = ' USE Tempdb;
SELECT CONVERT(VARCHAR(100), @@SERVERNAME) AS [server_name]
,[Link] AS [database_name]
,mf.[name] AS [file_logical_name]
,mf.[filename] AS[file_physical_name]
,convert(FLOAT, mf.[size]/128) AS [file_size_mb]
,convert(FLOAT, (mf.[size]/128 - (CAST(FILEPROPERTY(mf.[name],
''SpaceUsed'') AS int)/128))) as [available_space_mb]
,convert(DECIMAL(38,2), (CAST(FILEPROPERTY(mf.[name],
''SpaceUsed'') AS int)/128.0)/(mf.[size]/128.0))*100 as [percent_full]
FROM [Link] mf
JOIN master..sysdatabases db
ON [Link] = db_id()';
--PRINT @TEMPDBSQL;
insert into #tempdbfileusage
EXEC SP_EXECUTESQL @TEMPDBSQL;

/*************************************************************/
/****************** Database Log Usage ***********************/
/*************************************************************/
CREATE TABLE #LogSpace(
DBName VARCHAR(100),
LogSize VARCHAR(50),
LogSpaceUsed_Percent VARCHAR(100),
LStatus CHAR(1));

INSERT INTO #LogSpace

EXEC ('DBCC SQLPERF(LOGSPACE) WITH NO_INFOMSGS;');

/********************************************************************/
/****************** Long Running Transactions ***********************/
/********************************************************************/

CREATE TABLE #OpenTran_Detail(

[SPID] [varchar](20) NULL,
[TranID] [varchar](50) NULL,
[User_Tran] [varchar](5) NOT NULL,
[DBName] [nvarchar](250) NULL,
[Login_Time] [varchar](60) NULL,
[Duration] [varchar](20) NULL,
[Last_Batch] [varchar](200) NULL,
[Status] [nvarchar](50) NULL,
[LoginName] [nvarchar](250) NULL,
[HostName] [nvarchar](250) NULL,
[ProgramName] [nvarchar](250) NULL,
[CMD] [nvarchar](50) NULL,
[SQL] [nvarchar](max) NULL,
[Blocked] [varchar](6) NULL
);

/*************************************************************/
/****************** HTML Preparation *************************/
/*************************************************************/

DECLARE @TableHTML VARCHAR(MAX),

@StrSubject VARCHAR(100),
@Oriserver VARCHAR(100),
@Version VARCHAR(250),
@Edition VARCHAR(100),
@ISClustered VARCHAR(100),
@SP VARCHAR(100),
@ServerCollation VARCHAR(100),
@SingleUser VARCHAR(5),
@LicenseType VARCHAR(100),
@Cnt int,
@URL varchar(1000),
@Str varchar(1000),
@NoofCriErrors varchar(3)

-- Variable Assignment

SELECT @Version = @@version

SELECT @Edition = CONVERT(VARCHAR(100), serverproperty('Edition'))

SET @Cnt = 0
IF serverproperty('IsClustered') = 0
BEGIN
SELECT @ISClustered = 'No'
END
ELSE
BEGIN
SELECT @ISClustered = 'YES'
END
SELECT @SP = CONVERT(VARCHAR(100), SERVERPROPERTY ('productlevel'))

SELECT @ServerCollation = CONVERT(VARCHAR(100), SERVERPROPERTY ('Collation'))

SELECT @LicenseType = CONVERT(VARCHAR(100), SERVERPROPERTY ('LicenseType'))

SELECT @SingleUser = CASE SERVERPROPERTY ('IsSingleUser')

WHEN 1 THEN 'Yes'

WHEN 0 THEN 'No'
ELSE
'null' END
SELECT @OriServer = CONVERT(VARCHAR(50), SERVERPROPERTY('servername'))

SELECT @strSubject = 'Database Server Health Check ('+ CONVERT(VARCHAR(100),

@SERVERNAME) + ')'

SET @TableHTML =
'
'
SET @TableHTML = @TableHTML +
'<div><img align="right" src="Images/Logo_Image.jpg" style="height: 100px; width:
300px"/><H2><bold>Database Health
Check Report</bold></H2></div>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse:
collapse" bordercolor="#111111" width="47%" id="AutoNumber1" height="50">

<tr>
<td width="39%" height="22" bgcolor="#000080">
Server Name</td>

</tr>
<tr>
<td width="39%" height="27">' + @ServerName
+'</td>
</tr>
</table>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="933" border="2">

Version</td>

<td align="Center" width="17%" bgColor="#000080" height="15">

Edition</td>

<td align="Center" width="35%" bgColor="#000080" height="15">

Service Pack</td>

<td align="Center" width="60%" bgColor="#000080" height="15">

Collation</td>

<td align="Center" width="93%" bgColor="#000080" height="15">

LicenseType</td>

<td align="Center" width="40%" bgColor="#000080" height="15">

SingleUser</td>

<td align="Center" width="93%" bgColor="#000080" height="15">

Clustered</td>

</tr>
<tr>
<td align="Center" width="50%" height="27">'+@version +'</td>
<td align="Center" width="17%" height="27">'+@edition+'</td>
<td align="Center" width="18%" height="27">'+@SP+'</td>
<td align="Center" width="17%" height="27">'+@ServerCollation+'</td>
<td align="Center" width="25%" height="27">'+@LicenseType+'</td>
<td align="Center" width="25%" height="27">'+@SingleUser+'</td>
<td align="Center" width="93%" height="27">'+@isclustered+'</td>
</tr>'

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Instance last

Recycled</bold></H3>
<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="47%" bgColor="#ffffff" borderColorLight="#000000" border="2">

Last Recycle</th>

<th align="Center" width="50" bgColor="#000080">

Current DateTime</th>

<th align="Center" width="50" bgColor="#000080">

UpTimeInDays</th>

</tr>'

SELECT
@TableHTML = @TableHTML +
'<tr>
<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
LastRecycle ), '') +'</td>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
CurrentDate ), '') +'</td>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
UpTimeInDays ), '') +'</td>' +
'</tr>'
FROM
#RebootDetails

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Database

Status</bold></H3>
<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="47%" bgColor="#ffffff" borderColorLight="#000000" border="2">

ServerName</th>

<th align="Center" width="50" bgColor="#000080">

name</th>

<th align="Center" width="50" bgColor="#000080">

state_desc</th>

</tr>'

SELECT
@TableHTML = @TableHTML +
'<tr>
<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
name ), '') +'</td>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(10),
state ), '') +'</td>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
state_desc ), '') +'</td>' +
'</tr>'
--CASE WHEN state !=0 THEN
--'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100), name,state,state_desc ), '') +'</td>'
--ELSE
--'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100),'All Databases are ONLINE'), '') +'</td>'
--END +
FROM
#DBStatus

/* Free Disk Space Report /

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Disk Space

Report</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="47%" border="2">

Drive_Name</th>

<th align="Center" width="200" bgColor="#000080">
Free_Space_GB</th>

</tr>'
SELECT
@TableHTML = @TableHTML +
'<tr>
<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
DName ), '') +'</td>' +
CASE WHEN Free_GB < 30 THEN
'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100), Free_GB), '') +'</td>'
ELSE
'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100), Free_GB), '') +'</td>'
END +
'</tr>'
FROM
#FreeSpace

/ Tempdb File Usage */

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Tempdb File

Usage</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="933" border="2">

Database Name</th>

<th align="Center" width="300" bgColor="#000080">

File Name</th>

Physical Name</th>

<th align="Center" width="250" bgColor="#000080">

FileSize MB</th>

<th align="Center" width="200" bgColor="#000080">

Available MB</th>

<th align="Center" width="200" bgColor="#000080">

Percent_full </th>

</tr>'
select
@TableHTML = @TableHTML +
'<tr>' +
'<td align="Center">' + ISNULL(databasename, '') +
'</td>' +
'<td align="Center">' + ISNULL(FileName, '')
+'</td>' +
'<td align="Center">' + ISNULL(physicalName, '')
+'</td>' +
'<td align="Center">' + ISNULL(filesizeMB, '')
+'</td>' +
'<td align="Center">' + ISNULL(availableSpaceMB, '')
+'</td>' +
CASE WHEN CONVERT(DECIMAL(10,3),percentfull) >80.00 THEN
'<td align="Center">' +
ISNULL(percentfull, '') +'</td></tr>'

ELSE
'<td align="Center">' + ISNULL(percentfull, '')
+'</td></tr>' END
from
#tempdbfileusage

/ CPU Usage */

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>CPU

Usage</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="80%" border="2">

System Time</th>

<th align="Center" width="300" bgColor="#000080">

SQLProcessUtilization</th>

<th align="Center" width="250" bgColor="#000080">

SystemIdle</th>

<th align="Center" width="250" bgColor="#000080">

OtherProcessUtilization</th>

<th align="Center" width="200" bgColor="#000080">

load DateTime</th>

</tr>'
SELECT
@TableHTML = @TableHTML +
'<tr>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
EventTime2 ), '') +'</td>' +
'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100), SQLProcessUtilization ), '') +'</td>' +
'<td align="Center">' +
ISNULL(CONVERT(VARCHAR(100), SystemIdle ), '') +'</td>' +

'<td align="Center">' +

ISNULL(CONVERT(VARCHAR(100), OtherProcessUtilization ), '') +'</td>' +

'<td align="Center">' +

ISNULL(CONVERT(VARCHAR(100), load_date ), '') +'</td> </tr>'

FROM
#CPU ORDER BY EventTime2;

/* Memory Usage /

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Memory

Usage</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="47%" border="2">

Parameter</th>

<th align="left" width="200" bgColor="#000080">

Value</th>
</tr>'
SELECT
@TableHTML = @TableHTML +
'<tr>
<td>' + ISNULL(CONVERT(VARCHAR(200), Parameter ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), Value ), '')
+'</td>' +
'</tr>'
FROM
#Memory ORDER BY ID;

/* Database Backup Report /

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Latest Backup

status</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="47%" border="2">

<tr>
<th align="left" width="136" bgColor="#000080">
Database_Name</th>

<th align="left" width="200" bgColor="#000080">

Last_Backup</th>
<th align="left" width="200" bgColor="#000080">
Recovery Model</th>
<th align="left" width="200" bgColor="#000080">
DB Status</th>
<th align="left" width="200" bgColor="#000080">
Backup type</th>
<th align="left" width="200" bgColor="#000080">
Path</th>
</tr>'
SELECT
@TableHTML = @TableHTML +
'<tr>'+
'<td align="Center">' + ISNULL(name, '') +
'</td>' +
'<td align="Center">' + ISNULL(last_backup_time, '')
+'</td>' +
'<td align="Center">' + ISNULL(recovery_model_desc,
'') +'</td>' +
'<td align="Center">' + ISNULL(state_desc, '')
+'</td>' +
'<td align="Center">' + ISNULL(backup_type, '')
+'</td>' +
'<td align="Center">' + ISNULL(physical_device_name,
'') +'</td></tr>'

FROM #Backup_Report

/** Connection Information */

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Total Number of Database

Connections</bold></H3>
<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="47%" bgColor="#ffffff" borderColorLight="#000000" border="2">

Host Name</th>

<th align="Center" width="200" bgColor="#000080">

Total</th>

</tr>'

SELECT
@TableHTML = @TableHTML +
'<tr>
<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
Hostname ), '') +'</td>' +
'<td align="Center">' + ISNULL(CONVERT(VARCHAR(100),
NumberOfconn ), '') +'</td>' +
'</tr>'
FROM
#ConnInfo

/* Log Space Usage /

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Database Log Space

Usage</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="47%" border="2">

DatabaseName</th>

<th align="left" width="200" bgColor="#000080">

Log_Space_Used</th>

<th align="left" width="200" bgColor="#000080">

Log_Usage_%</th>

</tr>'
SELECT
@TableHTML = @TableHTML +
'<tr>
<td>' + ISNULL(CONVERT(VARCHAR(100), DBName ), '')
+'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), LogSize ),
'') +'</td>' +
CASE WHEN CONVERT(DECIMAL(10,3),LogSpaceUsed_Percent) >80.00 THEN
'<td>' +
ISNULL(CONVERT(VARCHAR(100), LogSpaceUsed_Percent ), '') +'</td>'
ELSE
'<td>' + ISNULL(CONVERT(VARCHAR(100),
LogSpaceUsed_Percent ), '') +'</td>'
END +
'</tr>'
FROM
#LogSpace

/** Job Info */

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>SQL Agent Jobs

Status</bold></H3>' +
'<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="933" bgColor="#ffffff" borderColorLight="#000000" border="2">
<tr>
<th align="left" width="430" bgColor="#000080">

Server_Name</th>

<th align="left" width="85" bgColor="#000080">

SQL_Job_Name</th>

<th align="left" width="183" bgColor="#000080">

RunDateTime</th>

<th align="left" width="136" bgColor="#000080">

Failure_Date</th>

<th align="left" width="136" bgColor="#000080">

StepDuration</th>

ExecutionStatus</th>

Error_Message</th>

</tr>'

SELECT
@TableHTML = ISNULL(CONVERT(VARCHAR(MAX), @TableHTML), 'No Job Running') +
'<tr><td>' + ISNULL(CONVERT(VARCHAR(100),
Server_Name), '') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), Step_Name),'')
+ '</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100),
SQL_Job_Name),'') + '</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100),
RunDateTime),'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100),
Failure_Date),'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100),
StepDuration),'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100),
ExecutionStatus),'') +'</td>' +
'<td>' +
ISNULL(CONVERT(VARCHAR(100),Error_Message ),'') + '</td></tr>'
FROM
#JobInfo

/** Blocking Information /

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Blocking Process

Information</bold></H3>
<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="933" bgColor="#ffffff" borderColorLight="#000000" border="2">

ServerName</th>

<th align="Center" width="50" bgColor="#000080">

SpID</th>

<th align="Center" width="50" bgColor="#000080">

BlockingSPID</th> <th

align="Center" width="50" bgColor="#000080">
ProgramName</th>

<th align="Center" width="50" bgColor="#000080">

LoginName</th>

<th align="Center" width="40" bgColor="#000080">

ObjName</th>

<th align="left" width="150" bgColor="#000080">

Query</th>

</tr>'

SELECT
@TableHTML = ISNULL(CONVERT(VARCHAR(MAX), @TableHTML), 'No Blockings found') +

'<tr>
<td>' + ISNULL(CONVERT(VARCHAR(100), @SERVERNAME ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), spid ), '')
+'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), Blkspid ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), PrgName ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), LoginName ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), ObjName ),
'') +'</td>' +
'<td>' + ISNULL(CONVERT(VARCHAR(100), Query ), '')
+'</td>' +
'</tr>'
FROM
#BlkProcesses
ORDER BY spid
/**** Long running Transactions*****/
SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>Long Running

Transactions</bold></H3>
<table id="AutoNumber1" style="BORDER-COLLAPSE: collapse" borderColor="#111111"
height="40" cellSpacing="0" cellPadding="0" width="933" border="2">

SPID</th>

TranID</th>

User_Tran</th>

DB_Name</th>

Login_Time</th>

<th align="Center" width="250" bgColor="#000080">

Duration</th>

Last_Batch</th>

<th align="Center" width="250" bgColor="#000080">

Status</th>

LoginName</th>

Host_Name</th>

PrgName</th>

CMD</th>

Blocked </th>

</tr>'
select
@TableHTML = ISNULL(CONVERT(VARCHAR(MAX), @TableHTML), 'No long running
transactions observed') +
'<tr>' +
'<td align="Center">' + ISNULL(SPID, '') +
'</td>' +
'<td align="Center">' + ISNULL(TranID, '')
+'</td>' +
'<td align="Center">' + ISNULL(User_Tran, '')
+'</td>' +
'<td align="Center">' + ISNULL(DBName, '')
+'</td>' +
'<td align="Center">' + ISNULL(Login_Time, '')
+'</td>' +
'<td align="Center">' + ISNULL(Duration, '')
+'</td>' +
'<td align="Center">' + ISNULL(Last_Batch, '')
+'</td>' +
'<td align="Center">' + ISNULL([Status], '')
+'</td>' +
'<td align="Center">' + ISNULL(LoginName, '')
+'</td>' +
'<td align="Center">' + ISNULL(HostName, '')
+'</td>' +
'<td align="Center">' + ISNULL(ProgramName, '')
+'</td>' +
'<td align="Center">' + ISNULL(CMD, '')
+'</td>' +
'<td align="Center">' + ISNULL([SQL], '')
+'</td>' +
'<td align="Center">' + ISNULL(Blocked, '')
+'</td></tr>'
from
#OpenTran_Detail

/* Error Log ***/

SELECT
@TableHTML = @TableHTML +
'</table>

<H3><bold>SQL

ErrorLog</bold></H3>' +
'<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="47%" bgColor="#ffffff" borderColorLight="#000000" border="1">

<tr>
<td width="20%" bgColor="#000080" height="15">
Check for Suspecious Errors - If
Any</td>
</tr>
</table>
<table style="BORDER-COLLAPSE: collapse" borderColor="#111111" cellPadding="0"
width="47%" bgColor="#ffffff" borderColorLight="#000000" border="2">

<tr>
<td width="20%" bgColor="#000080" height="15">
Error Log DateTime</td>

<td width="80%" bgColor="#000080" height="15">

Error Message</td>

</tr>';

SELECT
@TableHTML = @TableHTML + '<tr>
<td width="20%" height="27">'+
ISNULL(CONVERT(VARCHAR(100),LogDate ),'') +'</td>

<td width="80%" height="27"><font face="Verdana"

size="1">'+ISNULL(CONVERT(VARCHAR(2000),LogInfo ),'')+'</td>

</tr>'
FROM #ErrorLogInfo ORDER BY ID;

/**** End to HTML Formatting */

SELECT
@TableHTML = @TableHTML + '</table>' +
'

'

IF (@MailProfile IS NOT NULL AND @MailID IS NOT NULL)

BEGIN
EXEC [Link].sp_send_dbmail
@profile_name = @MailProfile,
@recipients = @MailID,
@subject = @strSubject,
@body = @TableHTML,
@body_format = 'HTML';
END

SELECT @TableHTML "HC_Report";

DROP TABLE #RebootDetails

DROP TABLE #FreeSpace;
DROP TABLE #BlkProcesses
DROP TABLE #ErrorLogInfo
DROP TABLE #CPU
DROP TABLE #Memory_BPool;
DROP TABLE #Memory_sys;
DROP TABLE #Memory_process;
DROP TABLE #Memory;
DROP TABLE #Backup_Report;
DROP TABLE #ConnInfo;
DROP TABLE #JobInfo;
DROP TABLE #tempdbfileusage;
DROP TABLE #LogSpace;
DROP TABLE #OpenTran_Detail;

SET NOCOUNT OFF;

SET ARITHABORT OFF;
END

SQL Server Health Check Report
No ratings yet
SQL Server Health Check Report
28 pages
Database Blocking Analysis Report
No ratings yet
Database Blocking Analysis Report
4 pages
sp_who3 SQL Server Procedure Creation
No ratings yet
sp_who3 SQL Server Procedure Creation
5 pages
SQL Query for Session Blocking Analysis
No ratings yet
SQL Query for Session Blocking Analysis
1 page
Analyzing SQL Server Sessions and Queries
No ratings yet
Analyzing SQL Server Sessions and Queries
42 pages
SQL Server Page Life Expectancy Script
No ratings yet
SQL Server Page Life Expectancy Script
29 pages
SQL Server Stored Procedure Health Check
No ratings yet
SQL Server Stored Procedure Health Check
6 pages
SQL Job Overview and Temporary Tables
No ratings yet
SQL Job Overview and Temporary Tables
24 pages
Coe Siebel Stats
No ratings yet
Coe Siebel Stats
8 pages
Script para Informes
No ratings yet
Script para Informes
49 pages
SQL Server DBA Performance Scripts
No ratings yet
SQL Server DBA Performance Scripts
31 pages
Process Status and SQL Monitoring Guide
No ratings yet
Process Status and SQL Monitoring Guide
4 pages
Oracle Job Queue Process Analysis
No ratings yet
Oracle Job Queue Process Analysis
6 pages
Oracle DB Issue Resolution Guide
100% (1)
Oracle DB Issue Resolution Guide
12 pages
Oracle Database Health Check Guide
100% (1)
Oracle Database Health Check Guide
14 pages
SQL Queries for Tablespace Management
No ratings yet
SQL Queries for Tablespace Management
10 pages
6 Login Sesseions Active - Inactive
No ratings yet
6 Login Sesseions Active - Inactive
4 pages
Database Management and Recovery Scripts
0% (1)
Database Management and Recovery Scripts
8 pages
SQL Server Health Check Report
No ratings yet
SQL Server Health Check Report
24 pages
SQL Server Who Is Active Procedure
No ratings yet
SQL Server Who Is Active Procedure
91 pages
Ola Hallengren SQL Server Maintenance
No ratings yet
Ola Hallengren SQL Server Maintenance
192 pages
RMAN Database Restore Info Script
No ratings yet
RMAN Database Restore Info Script
4 pages
I/O Waits and Performance Analysis in SQL
No ratings yet
I/O Waits and Performance Analysis in SQL
4 pages
All Scripts
100% (1)
All Scripts
88 pages
SQL Server Performance Tuning Scripts
No ratings yet
SQL Server Performance Tuning Scripts
15 pages
Oracle Memory Usage Monitoring Script
100% (1)
Oracle Memory Usage Monitoring Script
21 pages
Oracle Session Lock Management Queries
No ratings yet
Oracle Session Lock Management Queries
6 pages
DB2 Import/Export/Load Utility Guide
No ratings yet
DB2 Import/Export/Load Utility Guide
6 pages
MSSQL Memory and Performance Metrics
No ratings yet
MSSQL Memory and Performance Metrics
3 pages
Active Session and Lock Analysis
No ratings yet
Active Session and Lock Analysis
15 pages
SQL Server Blocking Query Detection
No ratings yet
SQL Server Blocking Query Detection
3 pages
Active Session Monitoring with CXSync
No ratings yet
Active Session Monitoring with CXSync
108 pages
SQL Plan Details for HANA Analysis
No ratings yet
SQL Plan Details for HANA Analysis
10 pages
SSIS Job Status and Failures Report
No ratings yet
SSIS Job Status and Failures Report
18 pages
Query
No ratings yet
Query
6 pages
Efficient Oracle Database Monitoring Scripts
100% (1)
Efficient Oracle Database Monitoring Scripts
45 pages
Database Health Check Overview
No ratings yet
Database Health Check Overview
2 pages
SQL DB Log and VLF Analysis Script
No ratings yet
SQL DB Log and VLF Analysis Script
3 pages
Oracle Database Monitoring Scripts Guide
No ratings yet
Oracle Database Monitoring Scripts Guide
47 pages
SQL Performance Issue Identification Script
100% (1)
SQL Performance Issue Identification Script
19 pages
SQL Server CPU Usage Troubleshooting
No ratings yet
SQL Server CPU Usage Troubleshooting
2 pages
Oracle DBA Maintenance Activity Checklist
No ratings yet
Oracle DBA Maintenance Activity Checklist
12 pages
Essential SQL Queries for DBAs
No ratings yet
Essential SQL Queries for DBAs
6 pages
Oracle Database Health Check Guide
100% (1)
Oracle Database Health Check Guide
15 pages
HANA SQL Expensive Statements Query
No ratings yet
HANA SQL Expensive Statements Query
4 pages
Oracle Database Performance Metrics Scripts
100% (2)
Oracle Database Performance Metrics Scripts
4 pages
Oracle Database Health Check Script
No ratings yet
Oracle Database Health Check Script
4 pages
SQL Server Database Overview Queries
No ratings yet
SQL Server Database Overview Queries
8 pages
SQL Server DBA Quick Reference Guide
100% (1)
SQL Server DBA Quick Reference Guide
13 pages
SQL Audit Specifications Overview
No ratings yet
SQL Audit Specifications Overview
4 pages
Essential Queries for Database Health Check
No ratings yet
Essential Queries for Database Health Check
6 pages
Top 20 Oracle DB Monitoring Scripts
No ratings yet
Top 20 Oracle DB Monitoring Scripts
10 pages
SQL Query for Database Backup Status
No ratings yet
SQL Query for Database Backup Status
1 page
DB Monitoring SQL Scripts for DBAs
No ratings yet
DB Monitoring SQL Scripts for DBAs
6 pages
Database Health Check Report
No ratings yet
Database Health Check Report
4 pages
SP Blitz
No ratings yet
SP Blitz
227 pages
Commvault DR Log Analysis Report
No ratings yet
Commvault DR Log Analysis Report
45 pages
Monitor Parallel Server Usage Alerts
No ratings yet
Monitor Parallel Server Usage Alerts
2 pages
Oracle Database Size and Session Queries
90% (10)
Oracle Database Size and Session Queries
57 pages
Calculate 2D & 3D Distances in Java
No ratings yet
Calculate 2D & 3D Distances in Java
9 pages
Cloud Computing Training at Insys
No ratings yet
Cloud Computing Training at Insys
23 pages
NumPy Data Analysis by Yash Gulati
No ratings yet
NumPy Data Analysis by Yash Gulati
3 pages
ICT Grade 7: Business Data Overview
No ratings yet
ICT Grade 7: Business Data Overview
7 pages
Spotlight - SentinelOne - Uninstalling The Agent - Cyber Vigilance
No ratings yet
Spotlight - SentinelOne - Uninstalling The Agent - Cyber Vigilance
2 pages
DevOps Engineer Resume: CI/CD & Kubernetes
No ratings yet
DevOps Engineer Resume: CI/CD & Kubernetes
3 pages
Astra V Elevator Control Manual v2.00
No ratings yet
Astra V Elevator Control Manual v2.00
38 pages
SQL Injection Lab: Exploiting Vulnerabilities
No ratings yet
SQL Injection Lab: Exploiting Vulnerabilities
26 pages
Essential Excel Formulas for Analysts
No ratings yet
Essential Excel Formulas for Analysts
5 pages
Linux Cut and Awk Command Guide
No ratings yet
Linux Cut and Awk Command Guide
2 pages
Understanding the ER Model Concepts
No ratings yet
Understanding the ER Model Concepts
39 pages
PCI-DSS and Crypto Key Management:: White Paper
No ratings yet
PCI-DSS and Crypto Key Management:: White Paper
10 pages
Practical Labs: Yocto Project and Openembedded Training
No ratings yet
Practical Labs: Yocto Project and Openembedded Training
24 pages
Attendance System Based On Face Recognition Face Mask and Body Temperature Detection On Raspberry Pi
No ratings yet
Attendance System Based On Face Recognition Face Mask and Body Temperature Detection On Raspberry Pi
5 pages
IGCSE Computer Science Notes: Data Representation
No ratings yet
IGCSE Computer Science Notes: Data Representation
22 pages
Quality Assurance in Software Development
No ratings yet
Quality Assurance in Software Development
7 pages
Introduction to MARIE Architecture
No ratings yet
Introduction to MARIE Architecture
68 pages
KCGG 151G Settings File Report
No ratings yet
KCGG 151G Settings File Report
2 pages
Lecture Slides 1 - Introduction To Programming
No ratings yet
Lecture Slides 1 - Introduction To Programming
24 pages
Encrypting Data Transfer in AAA
No ratings yet
Encrypting Data Transfer in AAA
78 pages
Understanding DOM and HTML Structure
No ratings yet
Understanding DOM and HTML Structure
5 pages
Java Programs for Primitive Types and Search
No ratings yet
Java Programs for Primitive Types and Search
70 pages
Spreadsheet Practical Questions Guide
No ratings yet
Spreadsheet Practical Questions Guide
9 pages
1 3JNSM2018Nr 5-6vol 3
No ratings yet
1 3JNSM2018Nr 5-6vol 3
19 pages
McDonald's Global Sales User Guide
No ratings yet
McDonald's Global Sales User Guide
103 pages
Android Compatibility Change Log
No ratings yet
Android Compatibility Change Log
1,246 pages
Secure Network Devices Lab Guide
No ratings yet
Secure Network Devices Lab Guide
11 pages
Pinterest Analytics Guide for Business
No ratings yet
Pinterest Analytics Guide for Business
18 pages
Naughty Beans Arcade Game Manual
100% (2)
Naughty Beans Arcade Game Manual
5 pages
Microsoft Publisher Certificate Exercise
100% (2)
Microsoft Publisher Certificate Exercise
1 page

SQL Server Health Check Report

Uploaded by

SQL Server Health Check Report

Uploaded by

/****************************************************************************/

-- Report Type: HTML Report Delivers to Output Window / Mailbox

IF EXISTS ( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].

DECLARE @ServerName VARCHAR(100);

CREATE TABLE #RebootDetails

CREATE TABLE #DBStatus

CREATE TABLE #ErrorLogInfo_all

CREATE TABLE #ErrorLogInfo

DECLARE @A VARCHAR(10), @B VARCHAR(10);

INSERT INTO #ErrorLogInfo (LogDate,LogInfo)

CREATE TABLE #FreeSpace (DName CHAR(1), Free_MB BIGINT, Free_GB DECIMAL(16,2))

CREATE TABLE #Memory_BPool (

-- SQL server 2008 / 2008 R2

---- SQL server 2012 / 2014 / 2016

CREATE TABLE #Memory_sys (

INSERT INTO #Memory_sys

CREATE TABLE #Memory_process(

INSERT INTO #Memory_process

CREATE TABLE #Memory(

INSERT INTO #Memory

-- Number of connection on the instance grouped by hostnames

DECLARE @TEMPDBSQL NVARCHAR(4000);

INSERT INTO #LogSpace

CREATE TABLE #OpenTran_Detail(

DECLARE @TableHTML VARCHAR(MAX),

SELECT @Version = @@version

SELECT @ServerCollation = CONVERT(VARCHAR(100), SERVERPROPERTY ('Collation'))

SELECT @LicenseType = CONVERT(VARCHAR(100), SERVERPROPERTY ('LicenseType'))

SELECT @SingleUser = CASE SERVERPROPERTY ('IsSingleUser')

WHEN 1 THEN 'Yes'

SELECT @strSubject = 'Database Server Health Check ('+ CONVERT(VARCHAR(100),

<font face="Verdana" color="#ffffff" size="1">Version</font></b></td>

<td align="Center" width="17%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">Edition</font></b></td>

<td align="Center" width="35%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">Service Pack</font></b></td>

<td align="Center" width="60%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">Collation</font></b></td>

<td align="Center" width="93%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">LicenseType</font></b></td>

<td align="Center" width="40%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">SingleUser</font></b></td>

<td align="Center" width="93%" bgColor="#000080" height="15"><b>

<font face="Verdana" color="#ffffff" size="1">Clustered</font></b></td>

<font face="Verdana" size="4" color="#3399ff"><H3><bold>Instance last

<font face="Verdana" size="1" color="#FFFFFF">Last Recycle</font></th>

<th align="Center" width="50" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">Current DateTime</font></th>

<th align="Center" width="50" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">UpTimeInDays</font></th>

<font face="Verdana" size="4" color="#3399ff"><H3><bold>Database

<font face="Verdana" size="1" color="#FFFFFF">ServerName</font></th>

<th align="Center" width="50" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">name</font></th>

<th align="Center" width="50" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">state_desc</font></th>

/***** Free Disk Space Report ****/

<font face="Verdana" size="4" color="#3399ff"><H3><bold>Disk Space

<font face="Verdana" size="1" color="#FFFFFF">Drive_Name</font></th>

/**** Tempdb File Usage *****/

<font face="Verdana" size="4" color="#3399ff"><H3><bold>Tempdb File

<font face="Verdana" size="1" color="#FFFFFF">Database Name</font></th>

<th align="Center" width="300" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">File Name</font></th>

<font face="Verdana" size="1" color="#FFFFFF">Physical Name</font></th>

<th align="Center" width="250" bgColor="#000080">

<th align="Center" width="200" bgColor="#000080">

<th align="Center" width="200" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">Percent_full </font></th>

/**** CPU Usage *****/

<font face="Verdana" size="4" color="#3399ff"><H3><bold>CPU

<font face="Verdana" size="1" color="#FFFFFF">System Time</font></th>

<th align="Center" width="300" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">SQLProcessUtilization</font></th>

<th align="Center" width="250" bgColor="#000080">

<font face="Verdana" size="1" color="#FFFFFF">SystemIdle</font></th>

/* Free Disk Space Report /

/ Tempdb File Usage */

/ CPU Usage */

/* Memory Usage /

/* Database Backup Report /

/** Connection Information */

/* Log Space Usage /

/** Job Info */

/** Blocking Information /

/* Error Log ***/

/**** End to HTML Formatting */