SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers

Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query, disable lock escalations and setting the database in Snapshot Isolation level. But nothing…

3

Performance of a Query on Computed Column can degrade in Sql 2005 with the increase in complexity of function in computed column

  With Sql server 2000 and 2005 computed columns can be use to improve the performance of queries since without the computed columns, indexes cannot be used as explained in the following blog by one of our Escalation Engineer Jack Li.   http://blogs.msdn.com/psssql/archive/2009/03/09/how-to-use-computed-columns-to-improve-query-performance.aspx   However in some cases, you may observe that a query on…


Queries May Appear to Run Slow on SQL SERVER COMPACT EDITION v3.1 Database

While running your application on SQL CE v3.1 databases you may observe slowness in the performance of some of the queries especially those which involve querying the primary key. In Sql server databases when you create a Primary Key on a column of a table, it will automatically create a unique index on the column…


Why Do I see more threads per SPID in sysprocesses than MAXDOP?

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server.   Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following blog by Bob Dorr from SQL Server Escalation Services, http://blogs.msdn.com/psssql/archive/2008/02/13/how-it-works-sql-server-per-query-degree-of-parallelism-worker-count-s.aspx  …

8

SQL Server can perform slow after changing the Cost Threshold for Parallelism

We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server.   Ironically in such cases we observe that sql server is performing slow even when there is no high CPU utilization and no high I/O operations on the…

1

Useful Documents while Troubleshootig Performance issues in the SQL Server 2005

The performance issue of the SQL Server can be anything from the connectivity issue of the application to Query running slow or query timeouts. So the first thing that we need to find out during the performance troubleshooting is to find what is the exact issue that we will troubleshoot. Finding the exact issue is…

0