Forum Replies Created
Viewing 15 posts - 16 through 30 (of 542 total)
-
Reply To: blocking by MSDTC txn
Thanks Johan.
Any way to get to know what -2 spid is doing within sql server? I want to know what query is being run through an MSDTC txn?
-
Reply To: need help in optimizing long running UPDATE statements
ScottPletcher wrote:Try these and see if they help. Be sure to review the query plan to verify:
INDEX ON mq: ( TABLE_NAME, ROWID_MQ_DATA_CHANGE )
UPDATE mq
SET mq.sent_state_id = 6,
UPDATED_BY... -
Reply To: Precuations of reducing the VLFs
Current VLF count info and AG properties.
AG properties
-
Reply To: Precuations of reducing the VLFs
Jeff Moden wrote:700GB log file for a 5TB database? Have you determined what caused it to grow that large and, if you reduce the size, will it grow to be that...
-
Reply To: Precuations of reducing the VLFs
If Jeffrey, thanks for your inputs. Have some doubts. please clarify.
For a 5TB database - a 700GB transaction log isn't out of the ordinary, and the fact that you only...
-
Reply To: blocking issue
One question application team/dev team had is, is there an option available to automatically commit txn's which are opened by the application when using Explicit txn? is there any option...
-
Reply To: blocking issue
After doing some research, got this query. For explicit transact, it will show "user_transaction" as txn_name,
if implicit_transaction is ON , then it is showing up as "implicit_transaction" as txn_name.
-
Reply To: blocking issue
is there way or using DMV we can tell an explicit transaction has been started by the session? we see so much blocking because of such sessions?
I am trying to...
-
Reply To: CXPACKET and SOS_Scheduler_yeild waits
maxdop is set to 1 at instance level and at database level it is set to 4. looks like each operator within plan is taking 4 threads
-
Reply To: recovery model for model database
Thank you.
-
Reply To: How to make this query Sargable
Thanks for your valuable inputs.
-
Reply To: IMPLICIT TRANSACTIONS
Thank you Ken and Jeff
-
Reply To: How to make this query Sargable
Stored proc code.
create procedure [dbo].[usp_domain_matching_idl]
as
begin
SET NOCOUNT ON
drop table if exists #domainextract
drop table if exists #party
drop table if exists #customers
drop table if exists #Prospects
drop table if exists #hyphenandsuspects
drop... -
Reply To: How to make this query Sargable
Thanks a lot frederico and Jeffrey. It means a lot !!
Felt that I have uploaded the stored procedure code. Uploading it now. I see lot of anti-patterns in this stored...
Viewing 15 posts - 16 through 30 (of 542 total)