Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BLOCKING & PERFORMANCE ISSUES IN SQL SERVER 2012 Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 1:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 26, Visits: 474

Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available with 48GB RAM. I gave 28gb for sql as max server memory. in event viewer after a day i got insufficient memory to run the query. There are lot of blockings so that application gets hanged and nothing is working fine. Could anyone suggest me in which aspect i should check the performance of sql.

Now i have increased as 38 gb out of total of 48 gb for sql server.

Server:sql server 2012 enterprise
OS:Windows server 2012 standard

In our applications we have long running threads with many joins ,but before there was no issues like blocking .....Problem started after Adding RAM & Processors ..Need to resolve blockings and run apps fastly . Any one please help me !!!!
Post #1462367
Posted Tuesday, June 11, 2013 2:11 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:50 PM
Points: 23,045, Visits: 31,570
Duplicate post. Please post any responses here.

Please don't make multiple posts. It will simply fragment any responses you may get regarding your problem.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1462370
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse