| Author |
Topic |
|
BlackReefDesigns
Starting Member
27 Posts |
 Posted - 2009-01-27 : 00:26:49
|
| I find myself constantly checking the memory usage on the site adxtactical.com Its always running 400+MB out of 512 MB. A few times I had to reset the server because I was starting to get error messages in my Control Panel and on the website (New Session Failed errors in the browser).It is just one site running on one SQL Database. Does this seem a bit high? GoDaddy.com won't let me upgrade my RAM on my Virtual Server because I "Have to purchase a dedicated plan to get more RAM". Do I have any options? Are there some apps I could maybe install to manage the memory usage or help it?I don't want to have to sit at the PC all day and monitor it =)BTW, what causes memory usage? Traffic?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 00:47:47
|
| About 22MB |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 18:09:25
|
| Hi Tara -Thank you for the reply.What steps should I take to diagnose and resolve this issue?GoDaddy.com is telling me to purchase a 'Dedicated Plan' so I can upgrade my memory. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-27 : 18:19:40
|
| Have you verified which process is actually using the memory? Is it SQL Server, IIS, or something else?CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-27 : 18:24:25
|
| first check if you're really having a problem with sql server consuming too much memory or your IIS proces w3wp.exe.if it's iis then you have a problem with your app code and not sql server. if so then i'd suggest that you run a .net profiler and profile your app for memory leaks.there are 2 that i used. one is redgate's ANTS profiler and the other is scitech's .net profiler.for memory problems i prefer the scitech's but redgate's for performance problems.both have 14-dy trial version which should be enough for you to find your problem.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 18:24:34
|
| He is the response from GoDaddy.comWe also show that you have installed SQL Server 2005 on the server at this time. We do not suggest using the full version of this software on the virtual dedicated servers as it is resource intensive. You may want to install SQL Server 2005 Express Edition on the server instead, this version is less resource intensive. We were able to see that the SQL Server process by itself was using 187 MB of RAM on the server. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-27 : 18:25:26
|
| simply open the task manager on your virutal server and check.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 19:16:12
|
| yes, I confirmed it is SQL Server that is taking up all the memory. Looks like I need to move to SQL Express.This is my first server I have ever set up and ran. How difficult/time consuming would it be to install SQL Server Express and remove the old SQL Server, while still keeping the same SQL Database? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 20:04:17
|
| Tara -I thought that SQL Express was what was already installed on my server. I just logged in and checked, and I AM running SQL Express already, not SQL Server? Now Im really confused |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BlackReefDesigns
Starting Member
27 Posts |
Posted - 2009-01-27 : 20:32:50
|
| ok, I sent them a reply to the support ticket. Am on standby right now until I hear back |
|
|
|
|
Why is my memory usage so high on my new website?