Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
runsaturday
Starting Member
3 Posts |
 Posted - 2009-03-20 : 10:05:39
|
| Hi AllI'm new to SQL Server - but have also been around databases as a developer for awhile.Currently I'm using an SQL 2005 Express database (will upgrade to a full 200x database soon) running on a 2008 server running IIS7.The server is not running particularly hot - it's generally at quite a low CPU level - but it is using most of its small amount of RAM (just 512MB).What's currently happening is that sometimes (between every 30 minutes and an hour) the server seems to start responding really very slowly - I've run SQL Profiler on this and it seems to go down to responding in times of up to 30 seconds to queries that it normally executes in well under a second.I'm a bit confused about where to look at the moment in order to try to work out where the problem is.It certainly doesn't feel like this is an "SQL-level" problem - it feels more like it's somewhere in the IIS, SQLServer or Win2k8 configuration.If anyone has any suggestions, then I'm all ears - as it's driving me crazy!ThanksStuart |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-03-20 : 10:56:25
|
| Have you checked for any sql server jobs, scheduled tasks or external backup jobs that might be running on an interval? What is the cpu-situation when this happens? If all else fails...can you unplug the machine from the network and see if it still happens?- Lumbago |
 |
|
|
runsaturday
Starting Member
3 Posts |
Posted - 2009-03-20 : 18:17:11
|
| The one thing that seems to have really helped is shutting down Microsoft Management Console - and hence freeing up a lot of RAM.Still a big confused... but beginning to wonder if available memory is the key issue... |
|
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2009-03-20 : 20:37:59
|
| check the cache hit ratio if that is below 90% then possibility is that the server is having memory issue also try to find out what query is running that is consuming the memory. If you have access to SQL Management Studio 2008 try using the activity monitoring tool, its a handy new utility, check out http://msdn.microsoft.com/en-us/library/ms175518.aspx for more detailsTechnologyYogihttp://gvphubli.blogspot.com/ |
|
|
|
runsaturday
Starting Member
3 Posts |
Posted - 2009-03-21 : 16:57:32
|
| Possibly a stupid question... Can I safely use SQL Management Studio 2008 with a 2005 SQL Express database? I'm assuming I can? But don't want to install it and then discover I can't afterwards - been there before! |
|
|
|
|
|
|
Server Performance - debugging