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 |
|
egemen_ates
Yak Posting Veteran
76 Posts |
 Posted - 2012-04-04 : 09:20:48
|
| im using sql server profiler for slow running query,my filter on duration column,duration > 30000 milisecond.this operation ,dangerous for the system?sql server profiler open during five or six hours. |
|
|
SQLSoldier
Master of MCMs
9 Posts |
Posted - 2012-04-05 : 20:11:54
|
| Using the Profiler application has an effect on the system. The less you profile, the less of an effect it has. Either way, you are much better off using a server-side trace or using extended events. Profiler can make your whole server run slow and effect what you are trying to profile.Robert L DavisMicrosoft Certified Master: SQL Server 2008Sr. Product Consultant and Chief SQL EvangelistIdera |
 |
|
|
|
|
|
sql server profiler