Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Profiler and troubleshooting.

0 views
Skip to first unread message

Hoardling1 via SQLMonster.com

unread,
Aug 19, 2009, 5:40:30 PM8/19/09
to
Anyone have any projects/solutions or SQL Profiler setups for troubleshooting.

I am just looking around trying to figure out good practices for
troubleshooting SQL Server 2008.
Trying to be ProActive instead of ReActive. What I am trying to do is build
a quick emergency plan to watch my database in case of troubles. Something I
can setup and when trouble happens I can execute and start figuring out what
has caused the problem. Like deadlocks, contentions etc..... Just asking
around for advice and what other DBAs are doing. I know this is very broad,
but someone might know something I total didn't know existed.

Thank You.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-performance/200908/1

Greg Linwood

unread,
Aug 19, 2009, 11:30:20 PM8/19/09
to
Our product SQLBenchmarkPro is purpose built to do exactly what you're
referring to:

http://www.SQLBenchmarkPro.com

SQLBenchmarkPro monitors SQL 2000 / 2005 & 2008 from a single installation

It is also the most light-weight server impact wise & fastest / most
accurate in trace file parsing / consumption

Cheers,
Greg Linwood

"Hoardling1 via SQLMonster.com" <u43783@uwe> wrote in message
news:9ad8fe2c9500f@uwe...

Uri Dimant

unread,
Aug 20, 2009, 1:20:16 AM8/20/09
to
Check it out
- SQL Server 2008 Diagnostic Information Queries
-- Glenn Berry
-- May 2009
-- http://glennberrysqlperformance.spaces.live.com/

"Hoardling1 via SQLMonster.com" <u43783@uwe> wrote in message
news:9ad8fe2c9500f@uwe...

Hoardling1 via SQLMonster.com

unread,
Aug 21, 2009, 10:44:14 AM8/21/09
to
Interesting product, kinda wish the web had more snapshots that you can zoom
in on. Hard to see what the product GUI looks like.

Greg Linwood wrote:
>Our product SQLBenchmarkPro is purpose built to do exactly what you're
>referring to:
>
>http://www.SQLBenchmarkPro.com
>
>SQLBenchmarkPro monitors SQL 2000 / 2005 & 2008 from a single installation
>
>It is also the most light-weight server impact wise & fastest / most
>accurate in trace file parsing / consumption
>
>Cheers,
>Greg Linwood
>

>> Anyone have any projects/solutions or SQL Profiler setups for
>> troubleshooting.

>[quoted text clipped - 13 lines]

Hoardling1 via SQLMonster.com

unread,
Aug 21, 2009, 10:45:05 AM8/21/09
to
Thank you, I copied Glenn Berry information and am reading through it.
Theres a bit, but I think it'll be helpful.

Uri Dimant wrote:
>Check it out
>- SQL Server 2008 Diagnostic Information Queries
>-- Glenn Berry
>-- May 2009
>-- http://glennberrysqlperformance.spaces.live.com/
>

>> Anyone have any projects/solutions or SQL Profiler setups for
>> troubleshooting.

>[quoted text clipped - 13 lines]
>>

0 new messages