Viewing 15 posts - 46 through 60 (of 712 total)
Hope it is Always on setup, any Database to read it has to be in Synchronising mode or Standby mode in log shipping. If it is suspended, the DB is...
Regards
Durai Nagarajan
August 4, 2022 at 7:23 am
is the above comments was the solution? what is the difference is execution plan post changes?
Regards
Durai Nagarajan
August 4, 2022 at 6:27 am
how about policies and access for your login/group. any error in Windows error log which you can post.
Do we have any other files in .....Setup Bootstrap\Log\20220802_031252\ folder?
Regards
Durai Nagarajan
August 4, 2022 at 6:25 am
Are you administrator in the server ? and check if the disk is compressed.
Regards
Durai Nagarajan
August 2, 2022 at 12:05 pm
Adding to above point , as it is C drive check if Antivirus or any other tools holds the file for SQL not to be able to access.
Try SQL service...
Regards
Durai Nagarajan
October 31, 2019 at 1:56 pm
try undocumented SP, for each individual DB query
EXEC sp_MSforeachdb @command
Note: Set full recovery plus full DB backup to secondary servers also necessary.
Regards
Durai Nagarajan
October 31, 2019 at 1:52 pm
This seems to be appear since older versions, i dont think any solution available as far as i know.
Regards
Durai Nagarajan
October 30, 2019 at 3:12 pm
Move the page file to separate drive as a best practice to avoid the IO on System drive, some put that in a SSD to have better performance.
Regards
Durai Nagarajan
November 15, 2018 at 12:46 am
Regards
Durai Nagarajan
November 15, 2018 at 12:40 am
Regards
Durai Nagarajan
November 29, 2017 at 5:55 am
What is the db compability level
Regards
Durai Nagarajan
November 29, 2017 at 4:35 am
Regards
Durai Nagarajan
November 28, 2017 at 9:49 pm
I got a strange problem, I am moving DBs from old test server(SQL Server 2008...
Regards
Durai Nagarajan
November 28, 2017 at 9:44 pm
There is no such direct recommendation for CPU utilization but you can check the performance using a monitoring tool, PerfMon or other SQL monitoring tools.
What is the RAM...
Regards
Durai Nagarajan
September 7, 2017 at 12:50 am
Mostly the DR or secondary servers will be of lower configuration as that of Primary. but based on your usage like reporting etc you can have almost of same configuration. Regards
Durai Nagarajan
September 6, 2017 at 11:55 pm
Viewing 15 posts - 46 through 60 (of 712 total)