Thanks .. So SQL instance could used 8 GB max memory .. just i want to know, is the normal usages?

For the best system, It should Target memory should be...

if any impact of tlog backup on mirror database in prinicpal server? is the any issues logs truncated by tlog backup in principal database. so how truncated data will apply...

Resolved CPU issues after changing few steps, now CPU usages 12 %

1. Adding missing index some tables which are not created before nonclustered index

2. Changed the default setting cost threshold...

Query is not a problem also facing any performance issues from user side but CPU always utilize 60 % constantly.

why index scan cost always 90% at every exectuion? please suggestion...

I checked that article, it should be UNSAFE Access in CLR object then only external resource will be used, so SAFE access not possible to set the CLR object.. But...

i have verified the which database has using CLR objects, there two type of CLR stored prcedure and CLR Scalar funtion. but these two objects CLR Permission is UNSAFE_ACCESS. it...

Thank you for posting Dead lock article, it is very useful for me

READ_WRITE dead lock frequently happaned in my production system, this is 3 rd party application and they...

There is one way deadlock resolution as below steps

Step 1: captured the SELECT Query from Deadlock graph

Step 2: created actual execution plan and found the Total Query cost is...

Thank you for identified the issues.. as you suggested i used sysname datatype on schema_name column and its worked..

For the above errors need to check as bleow points

1. N/W connection break and not stable

2. application not able to connect with user name & password which was mention exists...

I want to know if an issue with...

Thanks for your valuable replay..

I have verified in Application event log- Error apperaing related to SEP (symantec Endpoint Protection) due to updateing new version of SEP.. it was courrupted...

Due to that error AUTO SHIRNK enabled on that database..after disabled error was not appear in log file during transactions..

also log file inital size 1 GB and allow gorwth upto...

Bhuvnesh (10/17/2013)

---

This could be reason....

Bhuvnesh (10/16/2013)

---

Is the log drive being used by other things too like tempdb or data files ?

And what was the initiall size of this log file ? and have you...