Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Performance - indexes.

Author  Topic 

maevr
Posting Yak Master

169 Posts

Posted - 2013-09-08 : 16:34:16
Problems in a 2008 R2 environment, database grows quickly and deadlocks occure somtimes.

When I checked the database the tables lacked completely of indexes.

How can I find out which indexes that should be created and how to manage the deadlocks?

Performance monitor, query analyzer?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-09-09 : 01:47:22
There are lots of tools available. Use this guide to assist in analysing slow running queries - keep repeating - http://www.sqlserver-dba.com/2012/11/sql-server-how-to-troubleshoot-a-slow-running-query.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -