In QA env, multiple databases load tests goes in parallel and sometime they complain that server is slow intermittantly .

So, by using this query I ll be ablt to know...

Thanks everyone for sharing your inputs.

Sometimes we are seeing below patterns

"Application runs a query every 10 mins without any good reason."

There is a MERGE statement which does some...

To add to what Johan posted, your worst performing queries will NOT usually be your longest running queries and it may not be the queries themselves, at all... it...

With large tables, it's not likely that statistics are up to date (Frederico hinted at this in his post).  What are you doing to keep statistics up to date...

Thank you very much everyone. A lot of wise words.

This does the trick for me.

   WITH cteByDB AS
(--==== Preaggregate that data including a grand total using ROLLUP and marking that total row with...

The use of the SUM(OVER) Windowing function should do it for you.

I also have to ask... why to you need a "running total" for this?  Are you actually looking...

Many thanks Grant sir for the detailed explanation.

Thanks Jeff and Jonathan for the feedback.

Hi Jonathan,

Thanks for the input. I would like to know if there is any implications/perf issues of using MERGE statement especially when dealing large sets of data?

Hi Grant Sir,

Thanks for the pointers and sharing the link of capturing Waits. will check with them replace old join syntax's with ANSI joins.

Couple of questions:

1. for conditions like , ...

• This reply was modified 3 years, 5 months ago by vsamantha35.

As Grant said, there a few rows which are getting filtered out. Index creation of no use in this case.

Will ask them to work with the vendor.

Thank you Grant and...

Deny is a trump over all other security. So, you may have a complex set up where a given user, because they're in a group, has access to a...

Thanks for the clarifications. Many thanks.

Thanks Jeff.  Will those connections have any negative performance on SQL Server or is it normal?  What is the benefit that application would get?

Any help on how below script can be dynamically executed within the stored proc?

USE [master]

GO

CREATE LOGIN [Smith] WITH PASSWORD=N'SunRise#123', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON

GO

USE [SQLDBA_utils]

GO

CREATE USER [Smith] FOR LOGIN [Smith]

GO

USE [SQLDBA_utils]

GO

ALTER ROLE...