CH&HU (4/8/2009)

---

As this server reaches to 98% in CPU utilization and in performance level as well in RAM size.... 🙁

Let me know if anything about my presence was understood and...

you can turn off the trace flag using DBCC TRACEOFF.

Hi,

Check out BOL for trace flags description and the defnition.

you can turn on a trace flag globally using DBCC TRACEON(1222,-1) or through start up parameters but that needs a restart.

This...

prabha (4/8/2009)

---

Hi ,

As I said I want to recover the database before...

CH&HU (4/8/2009)

---

We have an audit table which stores the details of the errors on application. As you said the users are facing TimeOut errors and save profile errors, update errors....

There...

Hi,

I...

karan457 (4/8/2009)

---

Thanks for u r reply

i tried with un zip file also

that unzip .bak file i copied n pasted in default folder then

i tried to restore...

For automating tasks, its one of the powerful command language more like a python I would...

How did you confirm that you have dead lock issues? Did you turn on trace flag 1222? Are your front end users experiencing time out errors?

Did you take a look at the function fn_virtualfilestats or sys.dm_io_virtual_file_stats?...

What are you trying to run against the database? any integrity checks, rebuilding etc..??

It means the process you are running is not able to get an exclusive access on the...

Usually, I apply service packs as they come in and that too only once confirmed that they are not causing major differences to the way my production servers are configured....

kotlas7 (4/7/2009)

---

Now if we configure log shipping for all databases and transaction log backups taking place at every 15 mins. then do we need to disable the transaction log backups...

b:-D

????

You should look at avg_fragmentation_in_percent in sys.dm_db_index_physical _stats dmv, as a rule of...