Viewing 15 posts - 1 through 15 (of 332 total)
@ant-green
I removed the AOAG from the secondary too and reconfigured afresh. Now its in sync and healthy..thanks for your experienced advises.
June 19, 2023 at 12:59 pm
Hi @Ant-Green,
Yes the database is there in the AG MV02 in the secondary (now primary, as it failed over automatically as the Database in the primary(now secondary) had entered the...
June 8, 2023 at 10:27 am
@Ant-green
When I clicked on the 'Warnings' link from the dashboard, it says the replicas are not connected.I attached the screen shot of the same.Thank you.
June 1, 2023 at 12:31 pm
@Ant-Green
Where do I find the 'Always On Health extended event files' ? pls guide as I am completely new to AoAG.btw, I attached the Health state snapshot..Also since it doesnt...
June 1, 2023 at 12:19 pm
@Ant-Green
.There was an OS related system activity (patches) by system team and they restarted the server itself , directly multiple times brutally . can I set the HADR , ON...
June 1, 2023 at 11:57 am
for reference , i have attached the comparative state of the Availability groups and also how the database in question 'CITRIX_XD_CL' shows a changed-state (of Restoring).
Thanks and Regards.
June 1, 2023 at 9:05 am
sorry the bigges table is in 9 digits, 111 million records..and over a dozen in 10s of millions.
April 6, 2023 at 8:28 am
@AG , It was running as legacy. I just took over..I have removed 'Index Maint' from the activities..and also i m not getting any complaints on performance, suggesting , it...
April 6, 2023 at 8:19 am
@Sridevi kakolu,
Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , a query...
April 3, 2023 at 12:45 pm
Thank you Ant-Green. I have changed the maintenance plan and categorized the indexes rather into Rebuild and Reorganized categories depending on which side they fall on the 30% mark replacing...
March 30, 2023 at 9:30 am
Hi,
looking at other side of it, is there a way to reclaim the space on the drive after Index Rebuild ? thank you.
March 27, 2023 at 1:09 pm
Thanks everyone for your advices..I did a Rebuild of only selected indexes , with a frag percent more than 30% unlike the earlier maintenance plan that had a blanket Rebuild...
March 27, 2023 at 12:52 pm
Dear All,
Firstly , Thank you to all of you sharing your knowledge..The issue was with an Agent Jjob for Index Rebuild , done for all the Indexes irrespective of the...
March 22, 2023 at 12:59 pm
@Ant-green
The setting is 1000 and 100 respectively. Interestingly a newly instance I recently setup on the same server , (with both having identical settings above ),writes the history. More interesting...
February 17, 2023 at 1:45 pm
Hi All,
It was a permissions issue of the SQL server agent account on the directory . It couldn't write even being an administrator..I added specifically and it worked. However, though...
January 18, 2023 at 1:51 pm
Viewing 15 posts - 1 through 15 (of 332 total)