SQL Server Transactions Per Day

SQL Server Transactions Per Day

SQL Server Transactions Per Day

This post can help you in capturing SQL Server Transactions per day. Sometimes we need to capture the average number of transactions per day / hour / minute. Below is the T-SQL script that can help you to capture the SQL Server Transactions per day. Below script returns two result sets:

  1. Retrieves the total transactions occurred in SQL Server Instance since last restart
  2. Database Wise Average Transactions since last restart

T-SQL to capture SQL Server Transactions per day:

Here is the script file: SQL_Server_Transactions_Per_Day

These are the average values. To get the exact transaction details we can automate the capture process:

  • Create a table to capture the transaction counts since last restart
  • Create a stored procedure to capture the transactions since the last restart
  • Schedule a job to execute the procedure on hourly basis
  • Write a query to capture the hourly differences

 

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , | Leave a comment

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server post can help you in getting the index information from a database in SQL Server. There are two scripts provided:

Script 1: It captures all possible information of all indexes in the given database

Script 2: Captures the table wise number of indexes and total index size on a table

Script 3: Captures the index fragmentation details in the given database

TSQL script to get the index information in SQL Server:

 

TSQL script to get the index size and count in SQL Server:

 

TSQL script to get the index fragmentation details in SQL Server:

Here is the script file: TSQL script to get the index size and information in SQL Server

Posted in Performance Tuning, SQL Development | Tagged , , , , , , , , , , , | Leave a comment

Happy New Year 2017

Happy New Year 2017

Thanks to all our Readers, Authors, Advertisers and Partners for their everlasting support over the past 9 years. We really couldn’t do what we do without you all. Wish you a very Happy New Year 2017.

Team udayarumilli.com Wishing you a Happy New Year with the hope that you will have many blessings in the Brand New Year 2017 to come. Write it on your heart that every day is the best day in the year

List-out your priorities (Health, Family and Profession) today, make some resolutions and achieve your Goal.

Happy New Year 2017

happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017

Posted in Miscellaneous | Tagged , , , , , | Leave a comment