Karthick PK 's Blog - Site Home

Posts

| |

Karthick PK 's Blog

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)

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 12 Comments
Installation of SQLserver2008 cluster might fail on windows2008 with error mentioned below The cluster resource 'SQL Server' could not be brought online. Error: The group or resource is not in the correct state to perform the requested operation. ...
Karthick PK 's Blog

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

Posted 10 months ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
SQL Server I/O Bottlenecks ( I/O requests taking longer than 15 seconds to complete on file ) New version of this post in available in This link Do you see warnings like one below in your SQL Server error log? SQL Server has encountered ...
Karthick PK 's Blog

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

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
Error The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run. Error: 927, Severity: 14, State: 2. Database 'model' cannot be opened. It is in the middle of a restore. Could not create tempdb. You may not have...
Karthick PK 's Blog

How to Analyze "Deadlocked Schedulers" Dumps?

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 4 Comments
How to Analyze "Deadlocked Schedulers" Dumps? Newer version of this post is available in http://mssqlwiki.com/2010/06/15/how-to-analyze-deadlocked-schedulers-dumps/ Do you see "Deadlocked Schedulers" errors similar to one below and...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 5 Comments
Error === 2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode retail build) : Process ID 2428 2008-03-19 23:06:23 - ? [101] SQL Server SNETNAME version 9.00.3186 (0 connection limit) 2008-03-19 23:06:23 - ? [102...
Karthick PK 's Blog

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

Posted 10 months ago

by Karthick P.K - karthick krishnamurthy
- 3 Comments
A newer version of this post is available in THIS LINK A significant part of SQL Server process memory has been paged out. This may result in performance degradation. A significant part of sql server process memory has been paged...
Karthick PK 's Blog

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

Posted over 2 years ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
Problem Description : v Unable to start SQL Server 2005 default instance on a standalone server. v We notice below Error message in the SQL Server Error Log ...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 8 Comments
Problem ======= When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below error. Error: -------- SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer...
Karthick PK 's Blog

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

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
SQLServer2008: Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 574, state 0, severity 16 SQL Server 2012 : Script level upgrade for database 'master' failed because upgrade step ...
Karthick PK 's Blog

Kerberos Authentication in SQLServer

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
There are two authentication scheme which can be used by SQLserver when connecting to SQLserver using TCP/IP Protocol and windows authentication. 1. NTLM 2. Kerberos When we use Kerberos we get ability to delegate a principal's identity and it...
Karthick PK 's Blog

Different Status bits of sysdatabases in SQLServer

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 5 Comments
Sysdatabases.status and sysdatabases.status2 Bit of Sysdatabases in SQLServer ======================================================================== <Script1> declare @status int; declare @status2 int; Set @status='65544' --Replace your...
Karthick PK 's Blog

Installation of SQLServer2008 fails (The registry key SYSTEM\CurrentControlSet\Services\RsFx0102\InstancesShares is missing)

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
Installation of SQLServer2008 might fail with below error Detailed results: Feature: Database Engine Services Status: Failed: see logs for details MSI status: Passed Configuration status: Failed: see details below Configuration error code: 0xCD263ADC...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 3 Comments
When you choose to update statistics in your Maintenance Plan, and you have index on "computed column" in that database, the maintenance plan will fail with the following error: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL...
Karthick PK 's Blog

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"

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
DBCC CheckDB may with fail with error Error Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. Msg 7926, Level 16, State 1, Line 1 Check statement aborted. The database could not be checked...
Karthick PK 's Blog

SQLServer 2008 Fails to come online on cluster after upgrade

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
SQL-Server 2008 Fails to come online on cluster after upgrade. Reason : Server is in script upgrade mode . Only administrator can connect at this time . Login failed for user ‘ccccc\xxxxx. Reason : Server is in script upgrade mode . Only...
Karthick PK 's Blog

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

Posted 9 months ago

by Karthick P.K - karthick krishnamurthy
- 5 Comments
Do you see below errors in SQL error along with dumps and stuck? Non-yielding IOCP Listener * BEGIN STACK DUMP: * 05/06/12 03:54:59 spid 0 * Non-yielding IOCP Listener Non-yielding Scheduler * BEGIN STACK DUMP: * 04/16/12 10:09:58 spid 6256 * Non...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 6 Comments
The only possible way to add an IP to SQLServer2005 after adding new NIC to the node where SQLServer2005 is installed (or) After adding second ip address to existing NIC is to either manually edit the registry or run Service pack/Hotfix setup again. ...
Karthick PK 's Blog

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.

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 0 Comments
From management studio we do not see the SQL server and SQL Agent status. When we right click the instance, start, stop and resume options is disabled. WMI Permission could be a cause. Enable below permission in WMI. 1) --Open Dcomcnfg...
Karthick PK 's Blog

Troubleshooting SQL Server Memory

Posted 11 months ago

by Karthick P.K - karthick krishnamurthy
- 0 Comments
First step to troubleshoot SQL Server memory is to identify whether the whether the low memory condition appears to be in MemToLeave, or in the BPool. Note: If you do not know what is BPOOL or MemToLeave. Please read SQL Server Memory architecture...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 2 Comments
Table Variables (VS) Temp Tables SQLServer2005 caches temp tables and temp variables only under some conditions. Scenarios where temp table/variable are not cached (see below) may cause performance degradation as compared to SQLServer2000. Following...
Karthick PK 's Blog

Configuring SSL for SQL Server using Microsoft Certificate Authority Server

Posted over 3 years ago

by Karthick P.K - karthick krishnamurthy
- 0 Comments
Configuring SSL for SQL Server using Microsoft Certificate Authority Server Refer attached document for detailed steps 1. Install IIS Server from ADD/Remove Windows Components (if it is not installed already) 2. Install Certificate Server...
Karthick PK 's Blog

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

Posted 10 months ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
SQL Server CU’s update fails with error “ ScoException: The process cannot access the file 'C:\Windows\system32\ perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process...
Karthick PK 's Blog

SQL Server memory - Internals

Posted 2 months ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
SQL Server memory works in different ways in 32-Bit and 64-Bit operating systems. Let us have a deep dive in this blog on how SQL Server memory works in 32-Bit and 64-Bit systems. We will also see how SQL Server memory managers behave differently on different...
Karthick PK 's Blog

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

Posted over 4 years ago

by Karthick P.K - karthick krishnamurthy
- 1 Comments
Unable to connect to SQLServer listening on Non-Default Port? If you connect to SQLServer using the "hostname" it connects to the instance which is listening on 1433. If you make named instance listen on 1433 and connect using "hostname" it connects...
Karthick PK 's Blog

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

Posted over 2 years ago

by Karthick P.K - karthick krishnamurthy
- 3 Comments
When you use SQLDMO ??? Install SQL Server2005 Backward compatibility http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi Also remember if you have installed 32-Bit SQL Server on 64-Bit you have...