Viewing 15 posts - 1,261 through 1,275 (of 1,518 total)
madhu.arda (4/7/2008)
the query i got is from profiler output,so how can I get that full query?
if you know the spid no, you can run this:
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 10, 2008 at 3:35 pm
Ashwin M N (4/10/2008)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 10, 2008 at 6:50 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 9, 2008 at 10:40 am
I think this is roughly the same as what posted earlier. The OP is looking for Catalog Metadata\Cache hit ratio
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 8, 2008 at 12:52 pm
for cpu utilization, see my response in:
http://www.sqlservercentral.com/Forums/Topic480117-360-1.aspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 8, 2008 at 12:35 pm
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 7, 2008 at 7:54 pm
K. Brian Kelley (4/7/2008)
Tools are great and I'm all for them. However, having the script in your back pocket (or knowing...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 7, 2008 at 7:24 pm
It's a tough one - I did a google search, as I'm sure you did, and could not get anything...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 7, 2008 at 8:43 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 4, 2008 at 2:14 pm
... or save the query in a file, and specify file with full path in the DTA.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 4, 2008 at 1:58 pm
winston Smith (4/4/2008)
I can select The counter,...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 4, 2008 at 1:56 pm
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.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 4, 2008 at 8:15 am
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 3, 2008 at 7:55 pm
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....
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 3, 2008 at 7:13 pm
I read the reply on page 17: http://www.sqlservercentral.com/Forums/Topic449802-203-17.aspx
Scarry stuff...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 3, 2008 at 10:18 am
Viewing 15 posts - 1,261 through 1,275 (of 1,518 total)