if you know the spid no, you can run this:

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle...

Ashwin M N (4/10/2008)

---

Does the two part naming of a table helps in single Select statement in the application side, because I have lot of Select queries in the application...

Thanks, that's a great way of doing this, but I'm wondering, is it useful to apply this to all tables or just the larger ones? Any hints as to what...

I think this is roughly the same as what posted earlier. The OP is looking for Catalog Metadata\Cache hit ratio

for cpu utilization, see my response in:

http://www.sqlservercentral.com/Forums/Topic480117-360-1.aspx

If you are using SQL mail in a SQL job, the account under which the SQL Agent service is running should have access to the file share where the attachments...

K. Brian Kelley (4/7/2008)

---

Let me preface this by saying I intend no offense.

Tools are great and I'm all for them. However, having the script in your back pocket (or knowing...

It's a tough one - I did a google search, as I'm sure you did, and could not get anything...

This counter should be as close to 100% as possible.

On our systems the following query returns 0.999:

SELECT

ROUND(CAST (A.cntr_value1 AS NUMERIC) / CAST (B.cntr_value2 AS NUMERIC), 3) AS Buffer_Cache_Hit_Ratio

FROM

(

SELECT cntr_value AS...

... or save the query in a file, and specify file with full path in the DTA.

winston Smith (4/4/2008)

---

im trying to measure the amount of CPU used in a backup and restore, using the SQL Server Databases: Backup Restore counter in Perfmon.

I can select The counter,...

I see your problem now. Sorry, I have no ideas how to do this.

It's likely that this is not possible within the current capabilities of SSRS.

Not sure if I follow, but you need to define the conditions under which a parameter is to be shown or not.

Under Properties -> Visibility -> Hidden you can define...

In Report Manager, under Properties -> Security -> New Role Assignment you can configure the first group under the Browser role and the 3rd group under the Content Manager role....

I read the reply on page 17: http://www.sqlservercentral.com/Forums/Topic449802-203-17.aspx

Scarry stuff...