can any body plz advice on this issue

Thanks gail,

I turned on trace T1222.So far no dead lock is occrured. Could you please give some idea how to diagnose the above dead lock graph initially. I found the...

If I do DBCC TRACEON(1222,-1), the trace will be on for ever?

thank you,

we need to add this trace file in sartup parameters in configuration manager or there is another way to do it?

As we need to restart after adding this trace...

Thanks Gail,

After reviewing the results of select * from msdb..backupmediafamily

I observed that the backups are placed on D, E,F like 4 months ago. But as I know from last 3...

thank you

The drives are separate physical drives

Regarding item#2:

We have data files on D drive and log files on F drive and tempd on G drive and Backups are Z drive ,but still SQL BPA telling ...

Hi hanshi,

as you said We added a scheduled job to change the setting to ON just before the REORGANIZE of indexes and a job to set it back to OFF...

I still did not set the min and Max memory values. They are set to default values.Because sql server itself taking 15GB if I reduce the max value to 14GB...

Hi,

could you plz explain me the what is mean by the Paging File(\??\C:\pagefile.sys)\% Usage = 26.87484726 and Paging File(\??\C:\pagefile.sys)\% Usage Peak =80.45805841 and based on...

Yes, it is necessary to keep 4 insatnces on node3 as it is already in production...

plz advice me from the above analysis,what will be the best values for min max...

From the analysis, I got following values for Average Server Memory and page file usage as below

On node1:

INS1

Average Server Memory ...

So, there is no need to separate system databases mdf and ldf files to different drives?

If we moved mdf and ldf files if system databases to different drives where do...

hi Cain,

Previously, before applying SP2,I moved system databases mdf and ldf files to different drives.

All system databases mdf files are on E drive: E:\SQLData\INS1

master.mdf

model.mdf

msdbdata.mdf

mssqlsystemresource.mdf

mssqlsystemresource.ldf

distmdl.ldf

distmdl.mdf

All system databases ldf files are on...

Thanks,

I attached the Memory ananlysis excel sheet(taken at peak hours). based on these values could you please suggest me a guess for Min and Max server memory values and Page...