Viewing 15 posts - 61 through 75 (of 89 total)
my sysadmin likes doing that, and I told him don't do that again. Restart SQL server is NOT the option. Everything in memory will be wiped out when restarting. Try...
October 31, 2019 at 9:42 pm
Google some script on the web to check free space of the 257GB data file, I guess there will be some free space available. Until it's all used, autogrowth will...
October 31, 2019 at 1:18 am
Agree. this is the sensitive case I was involved. A consultant was hired by my employer to work on a payroll-related project. I provided access to live data and testing...
October 19, 2019 at 4:20 pm
both MSDTC and quorum belong to the cluster, not to a node, of course, it will be owned by a node. With one node(CANMTLDEVSQL1 ) only, quorum needs to be...
October 19, 2019 at 12:44 am
this is doable. Since CANMTLSQL2 was already shutdown, quorum, MSDTC, sql server, etc are all running on CANMTLDEVSQL1 and simply evict CANMTLSQL2 from failover cluster manager | node
October 18, 2019 at 2:56 pm
this is similar to what I did and still is in use. Every hour, I copy the transaction log backup to another workstation via powershell. An agent job restores the...
October 16, 2019 at 11:19 pm
yes, this could take a while if you didn't disable telemetry extended events. At least that's the case on my local SQL 2016 instance, although there is no load, only...
October 16, 2019 at 10:10 pm
I didn't do this before, but you can set up merge replication between SQL 2016 and SQL 2008. Select all tables and once snapshot is applied to subscriber/SQL 2008, you...
October 16, 2019 at 8:05 pm
Your database is write heavy(update/insert/delete). It should be fine. Or, change t-log backup to every 5 minutes from 15 minutes.
October 16, 2019 at 7:53 pm
I just did the same, so, I answer the questions I am aware of.
1. I have a 24 core physical server and am planning to purchase SQL core license. Since...
October 16, 2019 at 12:28 am
someone troubleshot similar issue and NIC teaming was the cause. It may not be the same, but it included a good reference to dig in.
https://qa.sqlservercentral.com/articles/workplace-encounters-grappling-with-async_network_io-waits
https://www.sqlshack.com/reducing-sql-server-async_network_io-wait-type/
October 15, 2019 at 2:08 am
I would suggest setting up a virtual machine and trying it out. Even if someone says it's OK, you still need to verify it and test the scenario before performing...
October 11, 2019 at 12:48 pm
I use https://www.sentryone.com/plan-explorer, even the professional edition is free now.
October 7, 2019 at 5:25 pm
3rd party monitoring tool is the best way to go. sys.dm_os_ring_buffers DMV provides very limited history for four hours and you can find scripts to parse the xml and get...
October 7, 2019 at 1:47 pm
this question was asked several times, if you have other holidays besides weekends(new year's day, christmas, labor day, etc), a calendar table is probably the best approach. You can create...
October 7, 2019 at 2:30 am
Viewing 15 posts - 61 through 75 (of 89 total)