Sign in
Karthick PK 's Blog
Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search Blogs
RSS Feed
RSS
http://mssqlwiki.com/
My other blogs
SQL Server 2012 Memory
SQL Server Exception , EXCEPTION_ACCESS_VIOLATION and SQL Server Assertion
What is RESOURCE_SEMAPHORE_QUERY_COMPILE?
Parameter sniffing
Optimizer Timeout or Optimizer memory abort
Troubleshooting SQL Server high CPU usage
SQL Server Latch & Debugging latch time out
SQL Server: Ghost records
I/O requests taking longer than 15 seconds to complete on file
Database Mail errors in SQL Server (Troubleshooting steps)
Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes
How to analyze Non-Yielding scheduler or Non-yielding IOCP Listener dumps ……
SQL Server generated Access Violation dumps while accessing oracle linked servers.
Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
A significant part of SQL Server process memory has been paged out
What is Target Server Memory (KB)?
SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.
Transaction log for the database is growing and system SPID is holding open transaction
Copy database wizard or replication setup might fail due to broken dependency
SQL Server Agent is taking long time to start
(SQLServer) Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
Multi Threaded OVELAPPED and Nonbuffered I/O Example
Asynchronous I/O example
SQL-Server resource fails to come online IS Alive check fails
The backup of the file or filegroup "" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
How to move the LOB data from one file group to other?
Linked server connection fails with “An error occurred during decryption”
SQL Saturday #116 : Don’t miss it
How to Create process in c++….. CreateProcess function
My “c:\” Drive gets full when I open the profiler trace
System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
how to Open CreateFile (Createfile example)
Beyond XP_READERRORLOG (Parameters of XP_READERRORLOG)
A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
How to get the current state of cluster resource?
Script to free cache
QueryMemoryResourceNotification & CreateMemoryResourceNotification (How SQL Server identifies low system memory on the system and respond to low system memory?)
How to find SQL Server and system CPU usage history :
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
Script to get current blocking tree with wait types
SQL Server2008/SQL Server2012: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
AWE allocator API’s (How SQL Server AWE works)
SQLServer 2008 Fails to come online on cluster after upgrade
How to rebuild index and update statistics for all the tables in database.
I get error while I update a row in immediate updating subscription what is the cause?
Tasks and connection icons missing after importing DTS in SQL Server management studio
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created
Runtime error: ActiveX component can’t create object: ‘SQLDMO.SQLServer’
How to check if local system is connected to a network and identify the type of network connection
I get Exception when i open SQL Server management studio
Tags
Connectivity
Encrytion
Engine
enterprise-it
Error: 15466)
Error: 574
Error: 701
Error: Error: 701
External dump process returned no errors
I/O requests taking longer than 15 seconds to complete on file
in memory sql server
InstancesShares is missing
ISAlive failure
Kerberos authentication
Linked server
Optimizer
Performance
Security
SQL General
sql server performance
SQLAgent
SQLOS
SQLServer Browser
SQLServer Cluster
SQLServer2008 Setup
Archive
Archives
March 2013
(1)
November 2012
(1)
August 2012
(1)
July 2012
(4)
June 2012
(3)
May 2012
(4)
April 2012
(1)
February 2012
(1)
January 2012
(1)
October 2011
(1)
September 2011
(1)
August 2011
(1)
March 2011
(1)
February 2011
(1)
November 2010
(3)
October 2010
(1)
June 2010
(2)
March 2010
(1)
August 2009
(2)
May 2009
(1)
April 2009
(3)
March 2009
(4)
February 2009
(1)
January 2009
(7)
Visitors map
Visitors from 16th Jan 2012
Blog - Link List
My site
MSSQLWIKI
February, 2011
MSDN Blogs
>
Karthick PK 's Blog
>
February, 2011
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Karthick PK 's Blog
SQL Agent MaxWorkerThreads and Agent subsystem
Posted
over 2 years ago
by
Karthick P.K - karthick krishnamurthy
1
Comments
In SQL Server Agent Execution of each supported job step is handled by a subsystem. Except for TSQL steps, each subsystem is handled by an external .dll file that is loaded into SQL Agent’s process at startup. Each subsystem takes information...
Page 1 of 1 (1 items)