Hello Jeff,

we take a look at the statistics at 10 a clock in the morning.

Only a view statistics were not up to date. And they were changed by the sql...

Hi,

we added some RAM, and the windows server got 96GB. We reserved 10GB for the OS.

The error was not reported since the upgrade.

Best regards,

Andreas

Hi,

please check, if the statistics and index are on the same "level", maybe rebuild them before your test.

And, check the mdop and the threshold for parallelism, and everything else which...

Hm,

your "sysadmin" was not able to find these accounts. And he was not able to create them?

Strange, I hope he knows what he is doing.

Hi,

is your account able to see every other account? I think, only a sysadmin can see every account.

And, these 2 accounts should exist on every sql server. Please check the...

Hello Steve,

thanks for this link. I will try my best, but we are not able to change the query, and we don't know when the error occurs.

Maybe the OS got...

Hi,

did you check, if the file exists on the drive?

How about the permission on these folders, is the service account able to delete files in the folder?

Kind Regards,

Andreas

Hi,

it is not helpful, if you start the same twice.

Please be so kind, and close on of your topics!

Have you tried to open the url on the report server, or...

Hello,

have you installed the newest version of SSMS?

Have you tried to start SSMS with administrator permission.

Have you tried, to start SSMS without any AddIn? (try to hit the shift-button until...

Hi,

can you show your t-sql, where the error happened?

Best regards,

Andreas

Hello,

have you tried to shrink in smaler trunks, like:

DBCC SHRINKFILE(db1_dat,921600);

We had sometime trouble to shrink, if the step was to big. We used smaler "steps", and every...

Hi,

we got this kind of error as well. We had a lot of domaincontroller. If one of them is in maintenance, or will just reboot, the sql server needs some...

Hi,

page count 2??

The Ola scripts work from above 1.000 pages.

"

MinNumberOfPages

Set a size, in pages; indexes with fewer number of pages are skipped for index maintenance. The default is 1000 pages....

Hi,

I think, these small icons ara just icons in the ssms, I wouldn't care about it.

Do you start the aoag dashboard from a single node, or from the listener. If...

Hi,

have you tried google?

https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#known-issues-190-preview-2

"Maintenance Plan The Maintenance Plan node is now available in Object Explorer."

Please update your ssms to the newest version, and the error should be fixed.

Kind...