The Curious Engineer

All blogs / Databases

Karthick PK 's Blog

learn.microsoft.com/en-us/archive/blogs/karthick_pk

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

DatabasesPerformance / optimizationWindows internalsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
46 from 14 Jan 2009 to 16 Mar 2013
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/karthick_pk/feed.xml

2013 1

  1. SQL Server memory - Internals

2012 16

  1. Query optimization
  2. Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes
  3. ASYNC_NETWORK_IO or NETWORK_IO
  4. Unable to open large profiler trace files
  5. Linked server connection fails with “An error occurred during decryption”
  6. The process cannot access the file 'C:Windowssystem32perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.
  7. I/O requests taking longer than 15 seconds to complete on file
  8. A significant part of SQL Server process memory has been paged out
  9. Troubleshooting SQL Server Memory
  10. What is Target Server Memory (KB)?
  11. Transaction log for the database is growing and system SPID is holding open transaction
  12. SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.
  13. Copy database wizard or replication setup might fail due to broken dependency
  14. SQL Server Agent is taking long time to start
  15. SQL-Server resource fails to come online IS Alive check fails
  16. Linked server connection fails with “An error occurred during decryption”

2011 5

  1. Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
  2. How to move the LOB data from one file group to other?
  3. Runtime error: ActiveX component can't create object: 'SQLDMO.SQLServer'
  4. Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788.
  5. SQL Agent MaxWorkerThreads and Agent subsystem

2010 7

  1. 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
  2. SQLServer: Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 574, state 0, severity 16
  3. Configuring SSL for SQL Server using Microsoft Certificate Authority Server
  4. SQLServer 2008 Fails to come online on cluster after upgrade
  5. How to Analyze "Deadlocked Schedulers" Dumps?
  6. 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.
  7. 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"

2009 17

  1. How to Trouble Shoot Transaction Log file Growth in SQLServer
  2. Unable to run SQLAgent job's in SQL server 2000 Service Pack 4
  3. How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.
  4. Different Status bits of sysdatabases in SQLServer
  5. Installation of SQLServer2008 fails (The registry key SYSTEMCurrentControlSetServicesRsFx0102InstancesShares is missing)
  6. 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)
  7. How to monitor the Session and query which Consumes Tempdb.
  8. Error 1934 returned when you run Update Statistics from a job against table that has index on computed column
  9. Using DMVs to find out the index usage history- SQLServer Index Usage
  10. Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.
  11. Kerberos Authentication in SQLServer
  12. Behavior of SQL Server default instance on a NON-Default port
  13. Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)
  14. How to Browse (or) view objects and there code in mssqlsystemresource Database
  15. How to enable Constraint delegation for SQLServer2005
  16. Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher
  17. Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008