Viewing 15 posts - 16 through 30 (of 31 total)
Thanks for sharing your inputs. Some observations before we resolved the issue.
The log_reuse_wait_desc was initially showing "Active_Transaction". Then we had to check with the application team and saw some...
March 5, 2021 at 9:49 am
Is there a proper way of capturing sql stmts which are causing the log file to grow abnormally ?
March 4, 2021 at 12:12 pm
No backups are written to these drives.
What is the right way of what is causing these I/O warnings and what needs to be captured or monitored?
February 11, 2021 at 10:43 am
Thanks Michael. After sql restart, the database went to Recovery pending state and we were able to drop the database.
February 3, 2021 at 10:04 am
Thank you for your guidance Brain.
January 6, 2021 at 7:21 am
Thanks you Jeff and everyone.
November 5, 2020 at 6:49 pm
I still didn't understand in what type of pages will the LOB data get stored ? apart from 8k data page are there any other type of pages to...
November 4, 2020 at 7:29 am
As per my understanding, LOB data will also get stored inside the page. However , if the row data is exceeding 8000 bytes, then the data is stored off the...
November 3, 2020 at 11:55 am
It's a POC server for 2017 upgrade. Waiting for a service pack to be released. I think only cumulative updates are available so far.
This database is a old database and...
November 3, 2020 at 5:23 am
Thanks for the clarification Grant & Mike.
February 24, 2020 at 6:06 pm
A picture of a plan isn't a plan, all the good stuff is in the properties.
However, assuming that estimated plan is correct, and you're getting a clean index seek,...
February 24, 2020 at 7:16 am
Not much you can do, I'm afraid. You either wait for the transaction to finish (in which case you may need to add more log space) or abort it...
February 24, 2020 at 6:58 am
February 21, 2020 at 6:47 am
I know that it won't seem like it should make any difference but try the following and see if it does...
set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD,...
February 21, 2020 at 6:38 am
No Triggers. But its a Heap Tbl.
February 21, 2020 at 4:23 am