Hi can you please provide me with WMI query to get the Server Name, instance names, IP address,OS_version,Dbms_version,Domain,Portnumbers for each instance

Thanks in advance

Hi Is there any query as such to remove all users except sa and system account users ?

DECLARE @file_exists int

DECLARE @MYFILE VARCHAR(300)

set@MYFILE='xxx_xxxx.xxx.xxxxx_xxxxxx_xxxxx_'+Replace(CONVERT(VARCHAR(8),GETDATE(),1),'/','_')+'.txt'

select @MYFILE

SET @file_exists=0

exec xp_fileexist @MYFILE, @file_exists OUTPUT

If @File_exists=1

do something xxxx

else

do something yyyy

solution for this issue is you need to make sure that log reader agent,Queue Reader agents are up if not start the agents and start the transactional subcription and...

No My Friend, this didnt work

what happens if we increase the RAM and the processors ?

will it bring the transactions per sec down

so after running the profiler how can we set the baseline for tarnsactions per sec ? On looking in to the rpc complete and batch process what should be...

I can see sudden jumps some times in the transactions per sec exceding to 3000 and some times 800 and what could be the reason for this sudden jumps...

what exactly we need to check in the RPC Completed and Batch Completed

what specific events i need to consider for running the profiler

on this specific issue ?

Thanks in advance

Q-what caused you to choose the 200 and 400 numbers?

Answer: i didn't choose that 200 and 400 that was set by our high level management:)

we were using the naigos tool for monitoring the performance of our server and the bounds for the total transactions per sec is set with the treshold 200-warning and 400-critical...

not more than 200 transactions per sec