question

jihene avatar image
jihene asked

Sql profiler et performance sur le serveur

bonjour ,

j'ai une trace qui enregiste dans une table et declenché à partir de sql profiler de mon instance local mais qui interroge un serveur de production ( elle trace toute les requetes de 5 users sur une base de prod). Est ce que cette trace non stop peut affectée la performance du serveur de prod svp ?

si oui comment je peut tracer l'activité de certaines personnes sans alourdir ?


Merci


profiler
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I have a trace which saves in a table and is triggered from sql profiler of my local instance but which queries a production server (it traces all the requests of 5 users on a prod database). Can this non-stop trace affect the performance of the prod server please?


if so how can I trace the activity of certain people without weighing it down?



0 Likes 0 ·

1 Answer

·
anthony.green avatar image
anthony.green answered

Tracing does have its overheads yes.

Depending where your running the actual trace from will depends also on the overhead.

If your running profiler locally to monitor a remote server then the overhead is not as bad to running profiler locally and monitoring locally.


But you really shouldn’t be using SQL profiler or SQL trace these days. They have both been added to the depreciated list and will be removed when Microsoft get round to it (if ever).

Use extended events instead these are much more lightweight than any trace or profiler will be.

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

merci pour votre retour :) justement mon profilr est chargé de mon serveur local mais interroge un serveur de production assez lourd déja !

0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.