New answers tagged profiler
Take a look here. It's a tool which genuinely tries to compare like with like in terms of database benchmarking!
in PostgreSQL you should use a tool called pgbench. it allows you to run custom scripts with an arbitrary number of concurrent requests and all that. it is also able to create random values for your script and all that - it is really powerful. for the test: make sure you got a proper setting for -j (number of threads used by pgbench) so that pgbench is able ...
Without seeing the plan and based on the information you provided, it sounds like you don't have that column, OrganisationID, in one of your existing indexes. Foreign keys aren't automatically indexed, so if it is part of your join or in the where clause then there could possibly be a benefit of adding the index. The missing index feature isn't always ...
The difference in logical reads leads me to believe that the two executions are getting different plans. This could be because: there are different set settings between the app that is calling the procedure that profiler is picking up and your instance of SSMS. you have a different default schema (you really should say exec dbo.SM_SP...). You can see if ...
Top 50 recent answers are included