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 |
|
reyboy
Starting Member
12 Posts |
 Posted - 2004-10-25 : 21:17:27
|
| Will it be ok if I run SQL Profiler daily?How much it would cost for my resources if I run SQL Profiler daily?How can I make SQL Profiler Run every time SQL Server Runs?Proud To Be Pinoy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-25 : 21:20:34
|
| Sure it's okay to run it daily but make sure you don't run it on the database server that you are profiling. Always use a client machine to run tools like this so that you don't impact performance on database server. Amount of resources is probably less than 5% but it depends where you run it from and how much data you are collecting. Why would you event want it to run every time SQL Server starts?Tara |
 |
|
|
reyboy
Starting Member
12 Posts |
Posted - 2004-10-25 : 21:40:05
|
| For small time biz in our area, management people would like all computers turned off at night where there are no transactions.Proud To Be Pinoy |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-10-25 : 22:24:17
|
| My Profiler presentation from a year ago has some information on automatically running traces at startup (http://www.sqlteam.com/item.asp?ItemID=15084). You might also benefit from a utility I wrote to automatically load those traces into a database (http://www.sqlteam.com/item.asp?ItemID=17336).===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
Need Advise in Daily SQL Profiler