News Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Swan's Blog:
Troubleshooting and Performance Tuning with SQL Server Traces
December 23, 2010 @ 12:02:41

Brian Swan has posted an example of debugging with SQL Server traces you can use in your PHP applications to help figure out what all's happening each time you run a query.

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.

0 comments voice your opinion now!
sqlserver performance troubleshoot tutorial traces


Till's Blog:
PEAR & Plesk
December 10, 2008 @ 09:34:15

In this new post to till's blog, he looks at a method for setting up PEAR on a Plesk system.

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.

0 comments voice your opinion now!
pear plesk install troubleshoot package controlpanel ssh


ComputerWorld.com:
Advanced PHP Solutions with Zeev Suraski (Webcast)
September 20, 2006 @ 15:58:36

If you missed the Zend Webcast talking about "Advanced PHP Solutions" with Zeev Suaski, ComputerWorld has your chance to grab the download from it.

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.

0 comments voice your opinion now!
webcast zend advance solutions webservices responsive speed scale troubleshoot webcast zend advance solutions webservices responsive speed scale troubleshoot



Community Events





Don't see your event here?
Let us know!


language symfony api install interview introduction framework community bugfix package laravel tips release zendserver series podcast library opinion update deployment

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework