How can I identify what applications (if any) use sqlservr.exe?

Hi Experts,

We are running SBS 2003.

sqlservr.exe is currently consuming about 680 MB of memory ("Mem Usage") out of our 2 GB RAM.

We are not running Exchange or ISA.

How can I identify what applications (if any) use sqlservr.exe?

Regards,
Leigh
LVL 1
LeighWardleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike ThomasConsultantCommented:
sqlservr.exe should run once per instance on your server.

It's a service, it's mem usage would go up and down depending on the load, i.e clients read/writing to the database/maintenace schedules etc.

If you do not need it look at disabling it.
0
LeighWardleAuthor Commented:
I have lost track on what apps that use SQL have been installed/uninstalled.
So that is why I am looking for some way to identify what applications (if any) use sqlservr.exe.
0
Kruger_monkeyCommented:
you could probably check what databases are created and see that way. It would depend on what you are running.  Neither exchange or ISA use SQL, but a lot of 3rd party applications do.

If you are only running a standard file/print/AD server then you can safely disable the sql service.

SQLserver is a database server which a lot of application use.  Review what you are running on your server and check their requirments.

If you open sql server management studio you can see a list of databases installed. Check what is listed and let us know.  
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

tickettCommented:
Launch SQL Server Profiler and run a trace. The trace will identify which applications/hosts/logins etc and talking to SQL.

L
0
chapmandewCommented:
Disable the sqlserver service. When things start breaking, reenable it. :)
0
St3veMaxCommented:
Give the code below a go. That should get you going.

HTH
--For SQL Server 2000 
Select 
	hostname
	,program_name
	,loginame
from 
	master..sysprocesses	
WHERE 
	spid > 50

--For SQL Server 2005/2008
SELECT
	[HOST_NAME]
	,PROGRAM_NAME 
	,login_name
	,client_interface_name
FROM
	sys.dm_exec_sessions 
WHERE
	session_id > 40

Open in new window

0
LeighWardleAuthor Commented:
The icon in the system tray reads:

SERVER\MICROSOFT##SSEE

That is Microsoft Sql Server Embedded Edition Service, not a full implementation of SQL Server.

I cannot see any way to access "sql server management studio" or "SQL Server Profiler"?


0
St3veMaxCommented:
Download "SQL Server Management Studio Express" and connect to your named instance and try the queries above.

HTH
0
beesterCommented:
Would the TASKLIST /SVC provide you with the correct information, in a cmd prompt?
0
subliferCommented:
If you're running any backup software, such as Backup Exec, then that is probably what is using SQL.  I used to use backup exec and it used that same default SSEE database.
0
subliferCommented:
Oh, you can also use process explorer to see what is running what

http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx
0
St3veMaxCommented:
Backup Exec by default installs SQL Express and uses an instance name of "SERVER\BKUPEXEC" so unlikley to be that unless you have been messing about.

Do as suggested, download SQL Management Studio Express and run the provided query. This will tell you what's running, from where and how it's connecting.
HOST_NAME	PROGRAM_NAME	login_name	client_interface_name
SS100005	Microsoft SQL Server Management Studio	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SILVER	SQLAgent - Generic Refresher	LOCAL\svc_SQLServerAgent	ODBC
SILVER	SQLAgent - TSQL JobStep (Job 0x6C2B488F410B4B47B61AA289F48CAD0C : Step 1)	LOCAL\svc_SQLServerAgent	ODBC
SILVER	SQLAgent - Email Logger	LOCAL\svc_SQLServerAgent	ODBC
SILVER	SQLAgent - TSQL JobStep (Job 0xD0AEB9A2A38988478C06C80E9DF2EF67 : Step 1)	LOCAL\svc_SQLServerAgent	ODBC
SILVER	SQLAgent - Alert Engine	LOCAL\svc_SQLServerAgent	ODBC
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SS100005	Microsoft SQL Server Management Studio	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQL Server Data Collector - Controller	LOCAL\svc_SQLServerAgent	OLEDB
SILVER	SQLAgent - Job invocation engine	LOCAL\svc_SQLServerAgent	ODBC
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100005	SQLDMO_1	LOCAL\adm_SteveM	ODBC
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100016	Microsoft SQL Server Management Studio	LOCAL\adm_DuncanG	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SILVER	DatabaseMail - SQLAGENT - Id<2420>	LOCAL\svc_SQLServerAgent	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider
SS100016	Microsoft SQL Server Management Studio	LOCAL\adm_DuncanG	.Net SqlClient Data Provider
SS100005	Microsoft SQL Server Management Studio - Query	LOCAL\adm_SteveM	.Net SqlClient Data Provider

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.