Archives: Memory

Know how shared is your server box and If Server runs with Default Settings

May 20, 2012 | By kiranbadi1991 | Comments Off on Know how shared is your server box and If Server runs with Default Settings | Filed in: Database, Development, Environment, Others, Performance Engineering, Testing.

Working on the shared environments or clustered environment is quite a challenge and getting the best performance out of the servers requires that we understand as how servers are been designed or maintained in the infrastructure. If during the load testing, we are continuously seeing a very high response time which continuously exceeds the SLA’s • Read More »

Tags: , , , , ,

Performance Counters to Identify Memory Issues in MS SQL Database

April 12, 2012 | By kiranbadi1991 | Comments Off on Performance Counters to Identify Memory Issues in MS SQL Database | Filed in: Database, Environment, Performance Engineering.

While monitoring the MS SQL Server I suggest keeping an eye on Buffer Manager/Memory Manager counter which can help us in identifying the memory contention issues in the MSSQL Database. The memory contention issues are quite easier to find in case we have single database hosted on the box and it becomes really hard job • Read More »

Tags: , , ,