Viewing 5 posts - 1 through 5 (of 5 total)
Thanks johnmcp… this was a big help...
November 12, 2019 at 3:52 am
GilaMonster (1/29/2013)
CXPacket waits are not an indication of poor performance. They're an indication that queries are running in parallel. That is all. If you have lots and lots and lots...
October 5, 2016 at 11:21 am
But now I have same issue again with a new twist. Temp db log file hos grown to 169 GB on the disk but If i try to shrink it...
April 3, 2016 at 6:04 am
Log file was empty. Shrink released little bit space but didnt help. Restarted the service but size didnt drop. Shrink also not worked after restart, just was not releasing any...
April 3, 2016 at 2:15 am
smitty-1088185 (6/23/2010)
It was an orphaned account in the MSDB database. The following two commands fixed it.exec sp_change_users_login ‘report’
EXEC sp_change_users_login 'Auto_Fix', '##MS_PolicyEventProcessingLogin##',NULL, 'Password01!';
Thanks a lot. This works.
April 3, 2016 at 2:03 am
Viewing 5 posts - 1 through 5 (of 5 total)