But something is not working after revoking the privileges,if I want to revert back to the privileges that I have before what should I do?

Did you reboot the all the nodes after installing CU11?

and do not stop any services before applying the CU11. It will detect the services and automatically stops them.

Hi,

I just tried to set the MAX memory to 12GB out of 16GB RAM and restarted the service.As soon as I set this MAX memory, Iam getting the procedure cache...

but without - before the trace file also working and from the error log I got the below message

...

I did this already DBCC SHRINKFILE (N'MSDBLog' , 500) . But the log file size still showing as 17Gb after shrinking the file!!!

Thank You,

On node1:default instance

Paging File(\??\C:\pagefile.sys)\% Usage =27.31262983

Paging File(\??\C:\pagefile.sys)\% Usage Peak ...

Hi Colin,

could you please give some idea based on these performance counters readings.I will appreciate all your help.

Thanks

Thanks Gail,

I would like shrink the log file of MSDb to minimum of keeping 500MB and want to keep in full recovery only to see if it again increases.what is...

Thanks Colin,

I setup performance counters for all the instances in all the 3 nodes. Below are the results, based on these results could you plz advice that do we really...

Thanks,

there is NO reindexing job is running. We are taking logbacks twice a day 10am and 6pm for user databases and only full backup for system databases. we have only...

My concern is why MSDB log is grown to 17 GB overnight? what are things do I need to check to know what is the reason to increase log size...

is it safe to keep the system databases in simple recovery model?

Thanks,

MSDB is in full recovery mode and we are taking only full back up of system databases every night.

and yesturday night the full backup size of msdb is 10MB only.Now...

thanks,

we have only backups stored on Z drive and page file located in C drive with default size of 2046 MB.

But Iam frequently getting these ararms, So what are the...

Thanks Manu...its resolved my issue.