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.
| Author |
Topic |
|
BigSam
Starting Member
30 Posts |
 Posted - 2006-06-07 : 10:30:03
|
| I've a full database backup & periodic transaction backups for a production database.Is there a way to restore the database to a different server & capture deadlock transaction information in SQL Profiler?Same question but capture information used by the Index Tuning Wizard?Thanks,BigsSam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-07 : 12:19:39
|
| You can't capture deadlock transaction information unless it is currently happening on the database that you are profiling. I don't know what you mean about capturing information by the ITW.If you restore the full backup and tlogs, then you now need to simulate a load on this database to capture the information. SQL Profiler is a real time application and can not go back in time.Tara Kizeraka tduggan |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-08 : 06:08:27
|
| Yes tkizer is right. We can findout the deaalocks throgh profiler by using of applications only.And Try Sp_readerrorlogThanksKK |
|
|
|
|
|
|
Profiler question