sqlagent.exe
Microsoft SQL Server by Microsoft Corporation (Signed)
| Version: | 2007.0100.2531.00 ((Katmai_PCU_Main).090329-1045 ) |
| MD5: | 12e6d95cde974b131defaa44bab8b056 |
| SHA1: | 89fd370fd98ed31d842a55b77faaf08c958d4937 |
| SHA256: | 3fef55d97915bdb222e3a60b50d53bbd8d9c0fdff85edc025b8efd33e575e596 |
What is sqlagent.exe?
SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2012. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.
About sqlagent.exe (from Microsoft Corporation)
“SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate thi”
Details
| File name: | sqlagent.exe |
| Publisher: | Microsoft Corporation |
| Product name: | Microsoft SQL Server |
| Description: | SQLAGENT - SQL Server Agent |
| Typical file path: | C:\Program Files\microsoft sql server\mssql10.mssqlserver\mssql\binn\sqlagent.exe |
| Original name: | SQLAGENT.DLL |
| File version: | 2007.0100.2531.00 ((Katmai_PCU_Main).090329-1045 ) |
| Product version: | 10.0.2531.0 |
| Size: | 417.85 KB (427,880 bytes) |
| Certificate |
| Issued to: | Microsoft Corporation |
| Authority (CA): | Microsoft Corporation |
| Effective date: | Monday, December 7, 2009 |
| Expiration date: | Monday, March 7, 2011 |
| Digital DNA |
| Entropy: | 6.200676 |
| File packed: | No |
| .NET CLR: | No |
More details
Programs
The following programs will install this file
The SQL Server Native Client contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server.
SQL Server 2005 introduced SQLXML 4.0, which continues to deliver the same functionality as SQLXML 3.0 plus additional updates provided to accommodate new features introduced with SQL Server 2005. SQLXML provides client-side XML functionality and enhancements to existing features, such as annotated XSD schemas, XML bulk load, Web services (SOAP) support, and updategrams.
“The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes the backward compatibility components for SQL Server 2005.”
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server Replication Management Objects (RMO) is a collection of objects that encapsulates SQL Server replication management.
Behaviors
Services
Runs under 'SYSTEM\CurrentControlSet\Services' by the Service Controller (services.exe)
- SQLAgent$MSSQL2008SERVER
- 'SQLSERVERAGENT' (SQL Server Agent (MSSQLSERVER))
- 'SQLAgent$R2'
Resource utilization
(Note: statistics below are averages based on a minimum sample size of 200 unique participants)
Averages
| CPU |
| Total CPU: | 0.00001355% | |
| Kernel CPU: | 0.00000788% | |
| User CPU: | 0.00000567% | |
| Kernel CPU time: | 16,723 ms/min | |
| Memory |
| Private memory: | 27.33 MB | |
| Private (maximum): | 7.06 MB | |
| Private (minimum): | 7.06 MB | |
| Non-paged memory: | 27.33 MB | |
| Virtual memory: | 526.04 MB | |
| Virtual memory (peak): | 529.53 MB | |
| Working set: | 7.06 MB | |
| Working set (peak): | 22.35 MB | |
| Resource allocations |
| Threads: | 15 | |
| Handles: | 461 | |
Process properties
| Platform: | 32-bit |
| Command line: | "C:\Program Files\microsoft sql server\mssql10.mssqlserver\mssql\binn\sqlagent.exe" -i mssqlserver |
| Owner: | SYSTEM |
| Windows Service |
| Service name: | SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT |
| Display name: | SQLAgent$MSSQL2008SERVER |
| Description: | “Executes jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks.” |
Distribution by Windows OS
| OS version | distribution |
| Windows 7 Ultimate |
42.50% |
|
| Windows 7 Home Premium |
25.00% |
|
| Microsoft Windows XP |
10.00% |
|
| Windows 8 Pro |
5.00% |
|
| Windows 8 Enterprise |
2.50% |
|
| Windows 7 Home Basic |
2.50% |
|
| Windows 7 Professional |
2.50% |
|
| Windows 7 Starter |
2.50% |
|
| Windows Server 2003, Standard Edition |
2.50% |
|
| Windows Server 2008 Standard |
2.50% |
|
| Windows Server 2012 Standard Evaluation |
2.50% |
|
Distribution by country
United States installs about 40.00% of Microsoft SQL Server.
Distribution by PC manufacturer
| PC Manufacturer | distribution |
| Toshiba |
29.63% |
|
| Dell |
22.22% |
|
| Acer |
11.11% |
|
| Samsung |
11.11% |
|
| Sony |
7.41% |
|
| Hewlett-Packard |
7.41% |
|
| Intel |
7.41% |
|
| GIGABYTE |
3.70% |
|
