Performance and logs

Hi,

I'm using SQL Server Management Studio Express and I have made a website
that uses a database with stored procedures.

When running pages in my webpages it cost around 2 seconds to load each
page.
Thanks too long!! But where is the problem?

I like to see a list of all executed stored procedures with there execute
time (for each page).
In this way I can check if the problem is here.

How can I get a logfile like this?

Thanks!

Performance tuning part of SQL Server does not come with Express, the Tuning Advisor which replaced the Index tuning Wizard, PerfMon and Profiler. The last can tell you stored proc duration and other statistics. Try the link below and download the eval which is good for 180days but it will be a good idea to buy the no deployment developer edition because it cost only $33. Hope this helps.

http://www.microsoft.com/sql/downloads/trial-software.mspx