March 1, 2011 at 4:39 am
Hi,
We just added two more instances on on my (development)sql box.( there are already 4 instances running on it.).but sice then i am experiencing memory related issue.sometimes some app related continue script migration got disturbed.sometimes backup job got failures.i am also experiencing frequent sql server restart while studying the sql error log and also "flush cache" related informational msgs there.
can anybody help me out what are the ways which can give me solid/concrete stats which shows memory shortage there.
Total memory : 6 GB
Every instances is taking average 0.8 GB.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 6:13 am
Have you set Min and Max Memory settings for each instances ?Is your box a 64 bit or a 32 bit ?
First thing I would monitor would be PLE,Buffer Cache ratio,Page Lookups/Sec,Page Reads/sec,Page writes/sec,Free List Stalls/sec and Lazy writes/sec.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 6:24 am
Sachin Nandanwar (3/1/2011)
Have you set Min and Max Memory settings for each instances ?
No
?Is your box a 64 bit or a 32 bit ?
no
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 6:26 am
Hi Bhuvenesh,
when ever your tempdb full then automatically sql server restarts so check that one and one more thing is are you checking any query which is running long period of time and check any deadlocks are there ...
March 1, 2011 at 10:34 pm
gsuvarnarekha (3/1/2011)
Hi Bhuvenesh,when ever your tempdb full then automatically sql server restarts so check that one and one more thing is are you checking any query which is running long period of time and check any deadlocks are there ...
I don't think SQL Server restarts automatically when tempdb is full.
Also deadlock is a different issue. It has nothing to do with this.
March 3, 2011 at 9:35 am
there is no need to have information on how to identify memory issues in your case. YOU HAVE MEMORY ISSUES - PERIOD. You simply cannot successfully run 4 instances of SQL Server successfully on a 6GB box.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 5, 2011 at 2:58 am
Suresh B. (3/1/2011)
I don't think SQL Server restarts automatically when tempdb is full.
No, but starving the OS of memory will!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2011 at 3:00 am
Bhuvnesh
32 bit or 64 bit operating system
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply