Karthick PK 's Blog

Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.

SQL Server memory - Internals

SQL Server memory works in different ways in 32-Bit and 64-Bit operating systems. Let us have a deep...

Date: 03/16/2013

Query optimization

If you would like to Optimize your SQL Server Query, Tune slow queries in SQL Server and make them...

Date: 11/21/2012

Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Do you see below errors in SQL error along with dumps and stuck? New version of this post in...

Date: 08/21/2012

ASYNC_NETWORK_IO or NETWORK_IO

What is ASYNC_NETWORK_IO  or  NETWORK_IO ? When a query is fired, SQL Server produces the...

Date: 07/27/2012

Unable to open large profiler trace files

Profiler filling up space of my system drive……. When you run the profiler trace (GUI) or open the...

Date: 07/21/2012

Linked server connection fails with “An error occurred during decryption”

    Problem Description   Linked server connection fails with below error { Failed to...

Date: 07/18/2012

The process cannot access the file 'C:Windowssystem32perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.

  SQL Server CU’s update fails with error “ScoException: The process cannot access the file...

Date: 07/16/2012

I/O requests taking longer than 15 seconds to complete on file

SQL Server I/O Bottlenecks ( I/O requests taking longer than 15 seconds to complete on file )  ...

Date: 06/26/2012

A significant part of SQL Server process memory has been paged out

    A newer version of this post is available in THIS LINK   A significant part of...

Date: 06/22/2012

Troubleshooting SQL Server Memory

First step to troubleshoot SQL Server memory is to identify whether the whether the low memory...

Date: 06/15/2012

What is Target Server Memory (KB)?

What is Target Server Memory (KB)?   To  super simplify  in conventional memory...

Date: 05/27/2012

Transaction log for the database is growing and system SPID is holding open transaction

Transaction log for the database is growing and system SPID is holding open transaction Select...

Date: 05/18/2012

SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.

  Do you know that adding additional RAM can affect the performance of SQL Server Sometimes?...

Date: 05/18/2012

Copy database wizard or replication setup might fail due to broken dependency

Copy database wizard would fail with below error while creating views or user defined functions if...

Date: 05/04/2012

SQL Server Agent is taking long time to start

  SQL Server Agent might take long time to start because of slow communications with...

Date: 04/19/2012

SQL-Server resource fails to come online IS Alive check fails

SQL-Server resource fails to come online with Error: [sqsrvres] checkODBCConnectError: sqlstate =...

Date: 02/01/2012

Linked server connection fails with “An error occurred during decryption”

  Problem Description Linked server connection fails with below error { Failed to retrieve data...

Date: 01/09/2012

Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“

Installation of SQL Server 2005 Service pack ,Hotfix and CU  would fail fails with “Unable to...

Date: 10/01/2011

How to move the LOB data from one file group to other?

  We do not have a direct way to move the LOB data from one file group to other. Using ALTER...

Date: 09/21/2011

Runtime error: ActiveX component can't create object: 'SQLDMO.SQLServer'

When you use SQLDMO ??? Install SQL Server2005 Backward compatibility...

Date: 08/07/2011

Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788.

Problem Description :   v  Unable to start SQL Server 2005 default instance on a...

Date: 03/05/2011

SQL Agent MaxWorkerThreads and Agent subsystem

    In SQL Server Agent Execution of each supported job step is handled by a subsystem....

Date: 02/01/2011

The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive

Error The database 'model' is marked RESTORING and is in a state that does not allow recovery to be...

Date: 11/25/2010

SQLServer: Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 574, state 0, severity 16

SQLServer2008: Script level upgrade for database 'master' failed because upgrade step...

Date: 11/17/2010

Configuring SSL for SQL Server using Microsoft Certificate Authority Server

Configuring SSL for SQL Server using Microsoft Certificate Authority Server Refer attached document...

Date: 11/17/2010

SQLServer 2008 Fails to come online on cluster after upgrade

SQL-Server 2008 Fails to come online on cluster after upgrade.   Reason: Server is in script...

Date: 10/30/2010

How to Analyze "Deadlocked Schedulers" Dumps?

How to Analyze "Deadlocked Schedulers" Dumps? Newer version of this post is available in...

Date: 06/22/2010

We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.

From management studio we do not see the SQL server and SQL Agent status. When we right click the...

Date: 06/20/2010

DBCC CheckDB fails with error "The database could not be checked as a database snapshot could not be created and the database or table could not be locked"

DBCC CheckDB may with fail with error Error Msg 5030, Level 16, State 12, Line 1 The database could...

Date: 03/06/2010

How to Trouble Shoot Transaction Log file Growth in SQLServer

How to Trouble Shoot T-Log file Growth============================ Enable the following TF for...

Date: 08/26/2009

Unable to run SQLAgent job's in SQL server 2000 Service Pack 4

Unable to run SQLAgent job's in SQLServer 2000 Service Pack 4 In SQL Server 2000 Service pack 4....

Date: 08/16/2009

How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.

The only possible way to add an IP to SQLServer2005 after adding new NIC to the node where...

Date: 04/11/2009

Different Status bits of sysdatabases in SQLServer

Sysdatabases.status and sysdatabases.status2 Bit of Sysdatabases in...

Date: 04/11/2009

Installation of SQLServer2008 fails (The registry key SYSTEMCurrentControlSetServicesRsFx0102InstancesShares is missing)

Installation of SQLServer2008 might fail with below error Detailed results: Feature: Database Engine...

Date: 04/10/2009

Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

Installation of SQLserver2008 cluster might fail on windows2008 with error mentioned below The...

Date: 03/26/2009

How to monitor the Session and query which Consumes Tempdb.

The total space used by tempdb equal to the User Objects plus the Internal Objects plus the Version...

Date: 03/26/2009

Error 1934 returned when you run Update Statistics from a job against table that has index on computed column

When you choose to update statistics in your Maintenance Plan, and you have index on "computed...

Date: 03/20/2009

Using DMVs to find out the index usage history- SQLServer Index Usage

SQLserver 2005 ships with a set of DMVs that can help you identify the missing indexes for your...

Date: 03/10/2009

Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.

Installation of SQLServer2005/2008 on Windows2008 Cluster might fail with error mentioned below ERR...

Date: 02/25/2009

Kerberos Authentication in SQLServer

There are two authentication scheme which can be used by SQLserver when connecting to SQLserver...

Date: 01/23/2009

Behavior of SQL Server default instance on a NON-Default port

Unable to connect to SQLServer listening on Non-Default Port? If you connect to SQLServer using the...

Date: 01/15/2009

Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)

Table Variables (VS) Temp Tables SQLServer2005 caches temp tables and temp variables only under some...

Date: 01/15/2009

How to Browse (or) view objects and there code in mssqlsystemresource Database

How to Browse (or) view mssqlsystemresource Database. 1. Stop the SQL Server service Copy the...

Date: 01/15/2009

How to enable Constraint delegation for SQLServer2005

Constraint delegation for SQLServer2005 Follow the below steps to set the constraint delegation for...

Date: 01/14/2009

Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher

Error=== 2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode...

Date: 01/14/2009

Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008

Problem=======When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below error....

Date: 01/14/2009