Thank you.

The query that is executing has several small queries. One part of the query is selecting data from one table1 in database1 where Id not in(select id from table1...

• This reply was modified 2 years, 2 months ago by  ramana3327.

Yes, # 8 is what I am seeing from SQL.

Does changing Maxdop & cost of threshold will effect other queries performance? These setting changes require SQL server restart?

The Parallelism settings for the server is below

Processors: 8

Cost threshold for Parallelism: 25 Locks: 0 Max Degree of Parallelism:0 Query Wait:-1

Thank you. I am not seeing any blocking from sp_who2 or select * from sys.dm_exec_requests where blocking_session_id <>0. But select * from sys.dm_os_waiting_tasks where blocking_session_id is not null giving me...

• This reply was modified 2 years, 2 months ago by  ramana3327.

I am seeing some blocking on server. Select *from sys.dm_os_waiting_tasks where blocking _session_id is not null giving about 70 records. Most of the wait_type is CXPACKET & Few wait_type is...

Update stats looks temporarily resolved the issue. I am again seeing overall performance maybe degraded because the system shows signs of being CPU bound message from the performance dashboard.

There is...

• This reply was modified 2 years, 2 months ago by  ramana3327.

Thanks everyone. Statistics update did the magic. The CPU inbound message is gone. Waiting for the confirmation from App tram

From the performan

The disk bytes/sec

last: 377,652,605 Avg: 1,091,938,363, Min: 209,067,244 , Max: 1,493,374,735

last: 204,419,027 Avg: 318,095,304  Min: 149,107,905 , Max: 638,625,164

IO Data bytes/sec

last: 393,516,961 Avg: 334,045,587 Min: 158,358,914 , Max:...

• This reply was modified 2 years, 2 months ago by  ramana3327.

Hi,

The databases has Auto statistics enabled. Some of the statistics are showing recent date. I updated on some tables.

Whenever I open the performance dashboard, the user sessions are 2-3 times...

Yes, I have sys admin previliages. I didn’t see any evidence that shows that someone took the database offline. How elevated account can process the cube with out the database?

Thank you. Yes, my SQL server memory settings are limited & leave the memory to OS. When SSAS is installed with default memory settings how it will work?

If SSAS is...

We have full backup job scheduled. We have about 10 databases on that instance. We are using powershell  script to backup. It will written the status of the back up...

Here is the full error message

[Timestamp]-username-server name: Execute{file name}

• This reply was modified 2 years, 3 months ago by  ramana3327.

Thank you. We’re using SQL2017.

If it’s not the data issue, what could be the other reasons? No errors reported in SQL server error log or event viewer. I assume if...

Thank you. There’s no issue with the file location or target. 70% of the databases are backing up and only few are failing. Also each when run the job manually...