Unfortunately, SQL Profiler (a tool that allows you to easily monitor server activity) is not included as part of SQL Server Express. Fortunately, SQL Profiler is just a nice UI for functionality that is built into SQL Server (including the Express version). So, in this post I'll show you how to create, read from, and write to a trace file using SQL and SQL Server Management Studio (which you can download for free from here).

He breaks the process down into a few steps with sample code and SQL for each:

• Create a trace (with the sp_trace_create stored procedure)
• Set the events to be monitored
• Filter trace data
• Start the trace
• Read trace data (this is where PHP comes in, code included)

With the results you can see things like read time, write time and CPU used for each part of the query making it simple to pick out the offenders.

Now running any config interface is a blog entry by itself and when I say Plesk, I should also mention confixx and cpanel. And while I have a strong dislike for all them, let me focus on Plesk for now. This is not a copy'n'paste howto, so make sure you double-check all steps involved. With little knowledge, you should be able to to apply all instructions to any other control panel, all you need is SSH access to the server.

The process includes two different sections - why your PEAR installation may not be working and how to install the PEAR packages (on any system supporting a package manager). Command line calls and configuration options are also included.

PHP continues to enjoy phenomenal growth becoming the de-facto standard for enterprise Web applications. With the introduction of PHP 5, PHP has reached new levels of support for Web Services, XML and Service Oriented Architectures (SOA) meeting the robust demands of the enterprise environment. Learn how you can achieve scalability, performance, availability and reliability for your enterprise-class PHP applications with advanced PHP solutions from Zend Technologies.

In the webcast, Zeev talks about integrating web services, tracking and improving the response times in your application, scaling your applications, and troubleshooting applications down to the exact line of code.