Profile cover photo
Profile photo
Ashok Kumar
64 followers
64 followers
About
Posts

Post has attachment
Important SQL Query
-------------------------- db growth plan query SELECT * FROM (SELECT @@servername [ServerName],[DbName],YEAR(ObsvDate) [Year],         convert(varchar(10),ObsvDate,121) [Date],        SUM(FileFreeSpaceMB) [FileFreeSpaceMB]       FROM [DBAdmin].[dbo].[DBA_M...
Add a comment...

Post has attachment
Microsoft SQL Server Buffer Cache Hit Ratio too low
Microsoft SQL Server Buffer Cache Hit Ratio too low Occurs when the buffer cache hit ratio falls below the  Buffer Cache Hit Ratio lower bound  threshold. The  buffer cache hit ratio  is the percentage of pages found in the buffer cache without having to re...
Add a comment...

Post has attachment
ERROR 1222 : Lock request time out period exceeded
ERROR 1222: Lock request time out period exceeded. It says find the offending transaction and terminate it and run the query again. Though sometimes there is a requirement that we cannot terminate anything. If we know which transaction is locking up resourc...
Add a comment...

Post has attachment
How to Check Index Fragmentation on Indexes in a Database
The following is a simple query that will list every index on every table in your database, ordered by percentage of index fragmentation.   SELECT   dbschemas.[ name ]  as   'Schema' , dbtables.[ name ]  as   'Table' , dbindexes.[ name ]  as   'Index' , ind...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Automate INDEX rebuild based on fragmentation results?
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED CREATE TABLE # FragmentedIndexes ( DatabaseName SYSNAME , SchemaName SYSNAME , TableName SYSNAME , IndexName SYSNAME , [ Fragmentation %] FLOAT ) INSERT INTO # FragmentedIndexes SELECT DB_NAME ( DB_ID ()) AS ...
Add a comment...

Post has attachment
how to configure Distributed AG in SQL 2016?
Configure  Distributed AG in SQL 2016 Before configure DAG Let look AG should need WSFC and Local drive  Distributed AG Configuration Pre-requisites : ============================================= 1. .Net framework 3.5 and failover cluster in server manager...
Add a comment...

Post has attachment
How to Remove Active/Passive node from SQL Server 2016 Failover Cluster with Demo
How to Remove Active/Passive node from SQL Server 2016 Failover Cluster Active and Passive Node: Active Passive Node SQL Services will be running on One Node only that means you should install SQL Server on first Node then you will add second Node to the fi...
Add a comment...

Post has attachment
To generate SQL Server Health Check Report via Database Mail in SQL
To generate SQL Server Health Check Report via Database Mail in SQL Step 1: we need to create following tables on SQL Server db CREATE TABLE [dbo].[backup_healthcheck]( [server_name] [varchar](100) NOT NULL, [database_name] [varchar](100) NOT NULL, [LastFul...
Add a comment...

Post has attachment
How to Solve Monitoring LSAlert Job Failed as Log shipping Report shows Red Even copy and restore Job Succeeded
How to Solve Monitoring LSAlert Job Failed as Log shipping Report shows Red Even copy and restore Job Succeeded Primary Server Primary Server LogShipping Report Secondary Server  Secondary Server  LogShipping Report Primary Server Job Info Secondary Server ...
Add a comment...
Wait while more posts are being loaded