Search Results | SQL Server Performance Forums

Post by: naga.rohitkumar, Dec 25, 2012 in forum: ALL SQL SERVER QUESTIONS

we use perfmon tool and addcounters like sqlserver buffermanger in the --->buffercache hit ratio and page read/sec,page write/sec.

Post by: naga.rohitkumar, Dec 2, 2012 in forum: ALL SQL SERVER QUESTIONS

thanks for the reply and details are as follows . 1. some times when application team try's to execute a simple query ' select count(*) from acmt...

Thread by: naga.rohitkumar, Nov 22, 2012, 3 replies, in forum: ALL SQL SERVER QUESTIONS

HI all SELECT Rtrim(CUST_ACID),rtrim(pmt_id),rtrim(AC_NAME),rtrim(txn_amt),rtrim(pmt_rmks) from payawdb.dbo.pmts,acmt where...

Thread by: naga.rohitkumar, Nov 21, 2012, 0 replies, in forum: SQL Server 2005 General DBA Questions

HI all which below services can be disabled and which cannot ?? if any linking with sql server Alerter Application Layer Gateway Service...

Post by: naga.rohitkumar, Nov 21, 2012 in forum: ALL SQL SERVER QUESTIONS

Thanks for the reply as a dba iam pefroming every thing like 1.taking top 10 long running queries and asking to application team for proper...

Thread by: naga.rohitkumar, Nov 21, 2012, 6 replies, in forum: ALL SQL SERVER QUESTIONS

HI to all, How to solve this issue sqlserver.exe is taking so much of memory [70%] in task manager --->in process --> sqlserver.exe is taking...

Thread by: naga.rohitkumar, Nov 21, 2012, 0 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

hi all 1. application team complaining that queries are executing slow and want reason for that in this case what should i do [or ] follow 2....