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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-11-29 : 15:03:03
|
| Hi allI need an input to trace the issue that we have. We have an Citrix application sometimes freeze for unknown reason and I did run PROFILER to check this and nothing I can see in term of locking etc etc. I just want to rule out that it's gotta nothing to do with DB.The problem with PROFILER is actually you can see the result when you activate this which we don't know when it's going to happen (it's like a random thing) and we can't afford it to run this 24 hours obviously.Is there anyway better way to the trace?Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-29 : 16:54:44
|
Does the Citrix app itself write to any sort of logfile? If so, I would start there.
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-29 : 21:44:52
|
| I don't think its a DB issue, as Citrix only use DB to do authentication, apart from that, nothing much, as you can see the citrix db is pretty small. My citrix knowledge was a bit old those, around 1 or 2 version ago so not too sure if its still the same in the latest.check network and make sure you configure citrix correctly, there are ways to config citrix to use less network bandwidth or set aside some bandwidth just for that etc etc....look more into the doc :) |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-11-30 : 05:49:36
|
| When I meantioned Citrix application, it doesn't mean the citrix itself but it's more third party application that uses Citrix.Regarding the PROFILER, does it really hit performance if you run 24 hours? |
|
|
|
negmat
Starting Member
20 Posts |
Posted - 2006-11-30 : 10:22:08
|
| Whether Profiler hits performance depends on the filters you use and how busy your server is.Server trace is an alternative to profiler with the following advantages over Profiler:- Less overhead- Can create stored procs to start, run and stop the trace and schedule the runs as jobs- Will not lose data even if server gets too busyCheck out the following:http://www.mssqltips.com/tip.asp?tip=1035http://www.dbazine.com/sql/sql-articles/larsen6 |
|
|
|
|
|
|
|
|
Tracing the Issue