Avatar of jdff
jdff

asked on 

double sqlservr.exe running

I see 2 instances of SQl server running on my SBS2011 server under the file sqlservr.exe and I have been trying to cap the memory size for it, however, one instance is a memory hog, can someone tell me why there are 2 of the same and how to fix the memory issue?

Thank you.
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
Vitor Montalvão
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

>> can someone tell me why there are 2 of the same

Right click those process in task manager and click "Open File Location" and see whether they are the same or in different path..
If different, then try to see the list of SQL Server services installed in SQL Server Configuration manager(probably an express edition or some other instance might be available on the server..)
Avatar of jdff
jdff

ASKER

there are may actually, i was not able to see file location when I right click on it, please look at the screenshot
04.png
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Suggestion to accept the above comments as solution.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo