Performance Tool - SQL Profiler

Question

Performance Tool - SQL Profiler

kayuca

Old Hand

Points: 356
More actions
April 15, 2008 at 2:00 pm

#184439

I'm going thru the Wrox Book "Professional SQL Server 2005 CLR Programming" and am stuck on page 36, uppermost paragraph where the authors mention using a tool to see what the auto-deployment and build processes are doing. I've written a few .NET Select, Updates, etc. but I'm still new to SQL.
The tool is: SQL Server 2005 -> Performance Tools -> SQL Profiler.
I have downloaded and installed SP 1 for SQL 2005, the Tools Kit and the Advanced Tools. But after all that, I still do not see any mention of Performance tools in my computer.
I don't know where else to look or how to proceed.
Help and advice anyone!
Thanks,
Victor Victor

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I'm assuming you downloaded SQL Express. Profiler's not included in that, it's only in the non-free editions.

If you want to learn and play, download the evaluation version of SQL. That should give you everything you need for 180 days. If you want more than that, search MS's site for SQL 2005 developer edition. It's all the power of enterprise edition (with a couple limitations) but not licensed for production usage. Last I checked, it was $50

Does the book come with a CD? If so, check that. They may have included the evaluation version of SQL.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

kayuca Old Hand Points: 356 More actions · Answer 2

G. Monster:

Thanks for the reply.

Yes, Express is what I have. No CD accompanies the book.

Hmmmm. In the book's Introduction, page xix, it says: "To follow along with this book, you'll need a copy of SQL Server Express 2005 at a minimum. ..."

I guess they made a mistake. So, I better get the 180 day free download.

Thanks,

Victor Victor

kayuca Old Hand Points: 356 More actions · Answer 3

G. Monster:

Many thanks. My recent download of the free 180 day SQL Enterprise edition contains the tools I needed. Problem one solved. However, a step forward requires two backwards.

Now I find that when I ask for a Visual Studio 2008 database project as shown in the same book (Wrox, Professional SQL Server 2005 CLR Programming), on pages 33 and 34, the "Add Database Reference" window fails to appear.

I have gone to the Surface Area tool and:

enabled CLR integration.

enabled remote connections,

enabled TCP/IP and named pipes

stopped and started the server after each change.

Boy, this is frustrating. Been wasting time on book inadequacies for well over a week now.

I must still be missing something but no longer know where to turn.

Any help here?

BTW. I am ready to throw this book out and start with a better written one. Do you have a recommendation on what that might be. I'm primarily a developer and not a DBA, but C#/SQL CLR are leading me into areas of DB that I have never been concerned with to date.

Thanks.

Victor Victor

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

What's the error you're getting?

I've never used Visual studio's database projects, so I can't be much help.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass