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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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 ) ...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy Date: 06/22/2012
Troubleshooting SQL Server Memory
First step to troubleshoot SQL Server memory is to identify whether the whether the low memory...
Author: Karthick P.K - karthick krishnamurthy Date: 06/15/2012
What is Target Server Memory (KB)?
What is Target Server Memory (KB)? To super simplify in conventional memory...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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?...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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 =...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy Date: 09/21/2011
Runtime error: ActiveX component can't create object: 'SQLDMO.SQLServer'
When you use SQLDMO ??? Install SQL Server2005 Backward compatibility...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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....
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy Date: 10/30/2010
How to Analyze "Deadlocked Schedulers" Dumps?
How to Analyze "Deadlocked Schedulers" Dumps? Newer version of this post is available in...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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....
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy Date: 04/11/2009
Different Status bits of sysdatabases in SQLServer
Sysdatabases.status and sysdatabases.status2 Bit of Sysdatabases in...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy Date: 02/25/2009
Kerberos Authentication in SQLServer
There are two authentication scheme which can be used by SQLserver when connecting to SQLserver...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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...
Author: Karthick P.K - karthick krishnamurthy 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....
Author: Karthick P.K - karthick krishnamurthy Date: 01/14/2009