Avatar of csePixelated
csePixelatedFlag for United States of America

asked on 

sql server 2008 r2 memory leak

we are running software that utilities sql server 2008, this software seems to run horribly
with 8 workstations using windows 7 this software hangs frequently when making calls to the sql server. sometimes windows even states it is unresponsive.
we checked the indexes on each table and some of the more frequently used tables had indexes of 90% fragmentation and up,
obviously we have been staying on top defraging of that but with 80 databases and 25 tables per database it takes some time.
we have also noticed that over time more errors / lag starts occurring,
and in monitoring the server in a couple weeks the ram usage of sqlserver.exe has climbed from a gig to 7gigs.
is it possible that the service installed on the server by our software vendor is causing a memory leak in sqlserver.exe

What other things could be leading to the issues we are having?

please note: the software vendor installs our software andthe sql server instance,
SoftwareMicrosoft SQL Server

Avatar of undefined
Last Comment
cheryl9063
SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America 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 cheryl9063
cheryl9063
Flag of United States of America 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.
ASKER CERTIFIED SOLUTION
Avatar of cheryl9063
cheryl9063
Flag of United States of America 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.
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