Viewing 15 posts - 166 through 180 (of 4,477 total)
The message is from long checkpoints. One of the first things you would want to check is the disk subsystem as that's often (not always) the issue. The following is...
February 5, 2020 at 3:16 pm
I think I know what happened... MSFT was sneaking in updates while I was testing. Gotta love invisible updates.
Probably. My mouse stops responding for a bit when they do...
February 5, 2020 at 12:30 am
It doesn't really sound like it's taking too long - sounds like seconds. Are you doing a full or incremental crawl? And how long is it taking? You can find...
February 5, 2020 at 12:25 am
You can use table partitioning with standard edition on SQL Server 2017. I believe starting with 2016 SP1 there is support for partitioning with all editions.
Sue
February 4, 2020 at 5:02 pm
Thanks for the feedback and please post back if you get anywhere with this. The similar issue I tracked down before took quite awhile to catch as it was happening...
February 4, 2020 at 4:25 pm
Stored procs, good call. I'll check there! And I know this seems obvious, but if I run dbcc opentran or look in sys.dm_tran_active_transactions and see "implicit_transaction" as the...
February 3, 2020 at 10:08 pm
And that's exactly what the article is talking about. Read the second line: The password policy applies to a login that uses SQL Server authentication, and to a contained database...
February 3, 2020 at 10:00 pm
The honest answer is that I am not certain, I would need to look at this closer. Sue may have some insight here.
Basically implicit transactions is the difference (imo)...
February 3, 2020 at 9:50 pm
Stored procs, good call. I'll check there! And I know this seems obvious, but if I run dbcc opentran or look in sys.dm_tran_active_transactions and see "implicit_transaction" as the name,...
February 3, 2020 at 9:43 pm
Directly setting SET IMPLICIT_TRANSACTIONS can be set in the application code, stored procedures so it's one thing to check.
Sue
February 3, 2020 at 9:09 pm
SET option might be one thing to check into as this can affect the issues you are having. Check the following documentation for details on this: SET IMPLICIT_TRANSACTIONS (Transact-SQL)
As...
February 3, 2020 at 7:16 pm
I think it's typical for a DBA to need to know the differences between a virtual machine and a physical machine as there are some differences in configuration, behavior and...
February 3, 2020 at 6:12 pm
It just enables the Windows local/domain policies when you select to enforce password policy. So you would want to check how it's setup in Windows for that server. Here is...
February 3, 2020 at 6:03 pm
Sue_H, screenshots which I shared last week were from the Extended events session for the Always on health.
Looking at one second of a log, extended events session is often...
February 3, 2020 at 5:48 pm
I verified that the user connect to right server and I was able to duplicate the same issues.
My Steps to duplicate:
1. Create SQL login = 'DBATest1' and assigned a...
February 3, 2020 at 5:39 pm
Viewing 15 posts - 166 through 180 (of 4,477 total)