• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

something has attached itself to my SQL Server. :(

P

PlatinumGold

Lifer
my sqlserver.exe keeps growing and growing even with no apps open other than IE.

does anyone know of something that would cause it, and how to get rid of it?
 
it got as big as 900 mb when you look at processes under task manager. there is no way this should be running at 900mb. i closed all process trees and restarted sql server, it started at 33mb and now it has grown to 43 mb in about 15 minutes.
 
we use msde at work , like SQL "lite" and i have seen this as a normal thing

why do you think it isn't supposed to do that?
 
That's not necessarily broken.

If you launch another app that uses lots of memory, does SQL Server relinquish memory?

If so, I'd say that SQL server is doing things well: it's using all the RAM it can until another app asks for the RAM.
 
Originally posted by: NogginBoink
That's not necessarily broken.

If you launch another app that uses lots of memory, does SQL Server relinquish memory?

If so, I'd say that SQL server is doing things well: it's using all the RAM it can until another app asks for the RAM.
Click to expand...

and that would make sense if it started off using a lot more ram.

oh well, i went into enterprise manager and changed the setting with regards to how much ram to make available.

also, i was wondering if it was the slammer virus. i'm not sure what the sympoms are tho.

 
Originally posted by: FoBoT
we use msde at work , like SQL "lite" and i have seen this as a normal thing

why do you think it isn't supposed to do that?
Click to expand...

like i said it's starts off at between 23 mb to 34 mb. but when it gets too 900 mb of ram some 6 or 7 hours later, i get concerned.

900 MB. the system only has 1 gb available and i start getting system resource errors.
 
Originally posted by: FoBoT
put a port monitor onto it to see if you have any connection that aren't supposed to be there

linked - Active ports
Click to expand...

nope, no connection that isn't supposed to be there, but over the last 3 hours sqlserver.exe went from 33mb to 111 mb.

and thats with NO ONE accessing the server. there is NO reason for it to be growing. 🙁
 
Just run SQL Profiler and see what the hell is going on. I'd probably check the active connections first. You can monitor the execution of sprocs, TSQL statements, ad nauseum.
 
Originally posted by: PlatinumGold
Originally posted by: NogginBoink
also, i was wondering if it was the slammer virus. i'm not sure what the sympoms are tho.
Click to expand...

LOTS of bandwidth usage. A quick look at your network usage should tell you... and of course if you're patched, you're fine. If you're not, you deserve a kick in the balls for breaking the internet for the rest of us 😉.
Click to expand...
 
Originally posted by: CTho9305
Originally posted by: PlatinumGold
Originally posted by: NogginBoink
also, i was wondering if it was the slammer virus. i'm not sure what the sympoms are tho.
Click to expand...

LOTS of bandwidth usage. A quick look at your network usage should tell you... and of course if you're patched, you're fine. If you're not, you deserve a kick in the balls for breaking the internet for the rest of us 😉.
Click to expand...

well, i tried installing SP3 with the patch and it wouldn't install. 🙁 it kept saying a previous process left something undone and that i'd have to restart, so i'd restart and i'd get same message. 🙁
Click to expand...
 
Originally posted by: PlatinumGold
Originally posted by: CTho9305
Originally posted by: PlatinumGold
Originally posted by: NogginBoink
also, i was wondering if it was the slammer virus. i'm not sure what the sympoms are tho.
Click to expand...

LOTS of bandwidth usage. A quick look at your network usage should tell you... and of course if you're patched, you're fine. If you're not, you deserve a kick in the balls for breaking the internet for the rest of us 😉.
Click to expand...

well, i tried installing SP3 with the patch and it wouldn't install. 🙁 it kept saying a previous process left something undone and that i'd have to restart, so i'd restart and i'd get same message. 🙁
Click to expand...



Your SQL server should be behind a firewall. Have you tried virus scanning?
Click to expand...
 
Originally posted by: Descartes
Seriously, instead of monitoring bandwidth, checking ports, etc., etc. just run SQL Profiler and question no more!
Click to expand...


i ran profiler and there was nothing unusual. well there was a lot of activity by the app that uses SQL Server. it's a synchro applet that synchs the sql data with another database. i would think activity from that applet would not be unusual.
 
Originally posted by: PlatinumGold
Originally posted by: Descartes
Seriously, instead of monitoring bandwidth, checking ports, etc., etc. just run SQL Profiler and question no more!
Click to expand...


i ran profiler and there was nothing unusual. well there was a lot of activity by the app that uses SQL Server. it's a synchro applet that synchs the sql data with another database. i would think activity from that applet would not be unusual.
Click to expand...

How big is the database?
 
Originally posted by: Descartes
Originally posted by: PlatinumGold
Originally posted by: Descartes
Seriously, instead of monitoring bandwidth, checking ports, etc., etc. just run SQL Profiler and question no more!
Click to expand...


i ran profiler and there was nothing unusual. well there was a lot of activity by the app that uses SQL Server. it's a synchro applet that synchs the sql data with another database. i would think activity from that applet would not be unusual.
Click to expand...

How big is the database?
Click to expand...

the one database is 3.7 gb, the other is about 100 mb. only the demographic data is synchro'd so only about 40 mb of data is synchrod.

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top