oh..i see your point.I didnt really make a note before i changed the setting but now i can see that sql is using only 32 mb of 43 gb. However...

Seems like its always been the same..i will further investigate..

Actually it is 20 writes and 7934149300 reads for one execution. In any scenario would it be normal for

7934149300 reads and 20 writes.

thanks

page cannot be found:hehe:

Thanks. I also came across that article. Do you changing trace flag from configuration manager and changing using query, does it have the same effect?

SQLkiwi (7/16/2010)

---

I should also mention that even if you are running 2005 SP3 CU4 (or 2008 SP1 CU2) onwards, you will need to enable trace flag 845 as a start-up...

SQL Server is running under domain account. Which account would you prefer?

GSquared (1/7/2011)

---

The problem with xp_cmdshell is that, if the account privileges are set even slightly wrong, it allows all kinds of nasty things to be done to the server.

It can,...

sqlbuddy123 (1/7/2011)

---

Pls Check this ,

Declare @path nvarchar(100) ...

Eric Russell 13013 (1/7/2011)

---

sqldba_icon (1/6/2011)

---

Yeah i can try that i think i might end up giving sa priviledge to the account since the app also kicks off few jobs...

I understand where the binaries are located. Basically i have 50 servers and i do not want to physically log into services console of each of these servers to find...

OK. I get it now.Basically we are using xp_cmdshell to transfer files..I have heard many saying xp_cmdshell should not be enabled but i do not see a reason why? Can...

thanks . Lets say there is a sql login "test" who has sa priviledge on sqlserver ServerA and doesnt have admin priviledge on the ServerA, still he can stop any...

Yeah i can try that i think i might end up giving sa priviledge to the account since the app also kicks off few jobs unless i manually give...