we use perfmon tool and addcounters like sqlserver buffermanger in the --->buffercache hit ratio and page read/sec,page write/sec.
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...
SELECT Rtrim(CUST_ACID),rtrim(pmt_id),rtrim(AC_NAME),rtrim(txn_amt),rtrim(pmt_rmks) from payawdb.dbo.pmts,acmt where...
which below services can be disabled and which cannot ?? if any linking with sql server
Application Layer Gateway Service...
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...
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...
1. application team complaining that queries are executing slow and want reason for that in this case what should i do [or ] follow
Separate names with a comma.