nawillia

We once had performance issues and was on a call with Microsoft on this.

I was told that SSMS is designed to...

What version of SQL & Windows it is ?

Are you trying from your Management studio client from your desktop or by remotely logging into the server?

If it is...

http://akifkamalsyed.wordpress.com/2012/09/16/how-to-configure-sql-server-performance-condition-alert-for-log-file-size/

This is a link which will help you to setup alerts.

You can choose your counters based on the object you choose.

I also sense the difference in settings between SSMS and the Application Server.

I will have to check it on the Application Server.

But I am not able to understand...

The wait types are CXPacket only.

I found online that having Arithabort ON could resolve this issue and tried that.

I did ran Profiler and yes it is the same query, which...

Gail

Thanks for the links on nolocks.

When I check the Profiler output it says

Parallel query worker thread was involved in a deadlock

No other information is...

Jeff

Most of the statements are Select statements.

Most of the imports are done by using SSIS packages and the script is created by the application itself.

Thanks Kevin.

I will check it out.

But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.

Dirty...

Thank you very much Gail.

It was very helpful 🙂

Yeah....That's what I have been thinking.

But this is just one output.

We have been having frequent deadlocks like this.

Changing at the query level is my recommendation.

MaxDOP is 0 and Cost...

Traceflag 1204 is off and this is the output of 1222.

,spid6s,Unknown,waiter id=process4a66748

,spid6s,Unknown,waiter-list

,spid6s,Unknown,owner id=process4a67b88

,spid6s,Unknown,owner id=process4a67dc8

,spid6s,Unknown,owner id=process4a67288

...