Statistic For Heavilly Used SPs

Apr 30, 2007

Hi,
Is there possibility to get somehow statistic for mostly used SPs in the SQL Server 2000 Database? Any field in sysobjects for number of executions for certian SP?

Thanks,
sqlzagi

View 2 Replies

F-Statistic

Oct 30, 2007

Has anyone implemented or knows an easy refernce to implement F-statistic for single variable linear regression? I was told it's not implemented in SSAS, so it seems like implementing it manually is the only way to go.

Thanks in advance,

View 1 Replies View Related

Statistic AddOn

Sep 10, 2003

hi,

i need to know if there is usefull Statistic AddOn available for the SQL-Server 2000

Anyhow exists somewhere on the www a site where all AddOn are collected?

thanx, birni

View 3 Replies View Related

Survey Statistic Query

Feb 5, 2007

Is there a possibility to express the text column with SELECT SQL command, to get AS column which will represent all values in the field?

I mean - to convert:

IDresult__IDquestion_answers
....
24______72_________178,180,191
25______77_________221,224
26______79_________291,298,301,302
27______84_________522,523,525
....

into:

IDresult__IDquestion_numberedanswers
....
24______72_________178
24______72_________180
24______72_________191
25______77_________221
25______77_________224
26______79_________291
26______79_________298
26______79_________301
26______79_________302
27______84_________522
27______84_________523
27______84_________525
....

Can SQL do that?

View 14 Replies View Related

Good Statistic For Blocking

Jan 14, 2004

We are having an occasional problem occur where a
process will not stop blocking.

We are trying to trace the problem, but in the interim,
I would like to set up an alert that notifies me when a
process has been blocking for too long.

Are any of the lock wait times good statistics to use
for such an alert? If not, is there anything else I could
look at from the alert level?

If I had to, I could periodically create a table of
sysprocess spids that are at the top of blocking chains,
then test for a spid that lingers. I'm hoping I can
avoid this and use the built-in monitoring instead, though.

Thanks!
Geoff

View 6 Replies View Related

SQL 2012 :: How To Determine When A Statistic Was Last Used By The Optimizer

Aug 25, 2015

Is there a DMV or similar in SQL 2012, or SQL 2008, that shows when a statistic was last used by the optimizer? I would like to cleanup some of the auto-generated stats, assuming it's possible to do so. In particular I'm looking to drop those statistics that were created by one-off queries, data loads, etc, and are now doing nothing but adding to the execution time of Update Statistics jobs.

View 6 Replies View Related

Generating A Daily Statistic Report SQL

Sep 10, 2007

Hi,

I Have a table below.
Query
PKEY id int
name varchar(128)
date_add DateTime

What is the SQL statement to get the number of query on each day?

the output should be date and quantity. There should still be an output even if there is no query on that day.

The only way I can think of is by a table-value UDF. (rough design)

function(startdate, enddate)
{
for each day from start to end
insert into result select count(*) from Query where date_add = currentDate
return
}

Is there a more efficient way to do this?

Thanks,
Max

View 1 Replies View Related