SQL Server Profiler

Using Profiler - SQL School Video

A basic tutorial that examines how Profiler can be used in SQL Server 2005 to monitor your SQL Server instance. MVP Brian Knight shows how to create a trace and the various options you have for monitoring events.

How to Track Down Deadlocks Using SQL Server 2005 Profiler

It is irritating, sometimes alarming, for the user to be confronted by the 'deadlock message' when a deadlock happens. It can be a tiresome business to prevent them from occurring in applications. Fortunately, the profiler can be used to help DBAs identify how deadlocking problems happen, and indicate the best way of minimising the likelihood of their reappearance.

Scripting Trace's for SQL 2005

How to Script Traces for SQL and Analysis Services

Introduction to SQL 2005 Profiler Part 1

Profiler is a tool that monitors the events and activity running on a SQL Server. Using profiler, this monitoring can be viewed, saved, and replayed. This article focuses on using Profiler with SQL Server 2005, but the tool is also included with SQL Server 2000 and SQL Server 2008.

Automating SQL Server Profiler

This article details the steps to automate the generation of Sql profiler traces in a Testing environment. The facility is useful when an application is User Acceptance Testing phase where a bunch of test users logon to the Testing site and use the application.

Using the kill to cure

Code profiling tools can help cure most performance problems, but sometimes the problem is so severe that you'll first need to know how to wield computing's least understood tool, the debugger, before diving in with the Profiler. Brian Donahue, Crash Scene Investigator, is on hand to explain why.

Write custom trace files in TSQL

SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace files in TSQL to catch events on your database machine.

RE: Restoring SQL Server without having the Data files?

Have a look in book online at article "Restoring the master Database from a Current Backup".  I think it will answer your question

RE: Connection to Server Failed (Analysis Sevices)

P.S.I can ping it using the servers text name.