missing value

hi,

I am using time series algorithm.and my prediction query is like this

SELECT PredictTimeSeries([Performance]) FROM [Stud_Model]

The output is like this

Date Perf

9/11/2006 90

10/11/2006 92

11/11/2006 93

12/11/2006 -- (no prediction)

1/11/2007 --(no prediction)

I dnt know why there is no prediction after certail date?

Thanks,

Karthik

The time series algorithm is based on regression trees which can become unstable as you move away from the time horizon, since you have predictions based on predictions. The algorithm tries to detect when this instability occurs and stops predicting at that point.

In future releases, we will have more user control over prediction stability and the behavior of the algorithm around this stability.

Missing SQL Server 2000 Performance Counters

I installed SQL Server 2000 w/SP4 on a x64 Windows 2003 OS. I found that I
did not have access to the SQL performance counters and it is the same on
other servers with the same combination. Has anyone run into this issue?
What's the solution to it? thanks.Hi Jason,
Thank you for your post.
I understand that you can not view the Performance Counters of SQL Server
on a 64bit OS. If I misunderstood your concern, please feel free to let me
know.
A 64-bit perfmon client app can view OS counters plus counters for any
application that has installed a 64-bit perfmon DLL (a 64-bit app can't
load a 32-bit DLL). This means that a 64-bit perfmon client app can see a
local 64-bit SQL instance's counters, but not counters for a local 32-bit
instance running in WOW64.
A possible workaround to this problem could be:
Please run "mmc /32 perfmon.msc" from Start-Run. Please let me know whether
you can see the perfmon counters for 32-bit sql server or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Missing SQL Server 2000 Performance Counters

I installed SQL Server 2000 w/SP4 on a x64 Windows 2003 OS. I found that I
did not have access to the SQL performance counters and it is the same on
other servers with the same combination. Has anyone run into this issue?
What's the solution to it? thanks.Hi Jason,
Thank you for your post.
I understand that you can not view the Performance Counters of SQL Server
on a 64bit OS. If I misunderstood your concern, please feel free to let me
know.
A 64-bit perfmon client app can view OS counters plus counters for any
application that has installed a 64-bit perfmon DLL (a 64-bit app can't
load a 32-bit DLL). This means that a 64-bit perfmon client app can see a
local 64-bit SQL instance's counters, but not counters for a local 32-bit
instance running in WOW64.
A possible workaround to this problem could be:
Please run "mmc /32 perfmon.msc" from Start-Run. Please let me know whether
you can see the perfmon counters for 32-bit sql server or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Since this thread is already closed, here is a link to it:
http://groups.google.co.uk/group/mi...5989f5fc6817daa
"I installed SQL Server 2000 w/SP4 on a x64 Windows 2003 OS. I found
that I
did not have access to the SQL performance counters and it is the same
on
other servers with the same combination. Has anyone run into this
issue?
What's the solution to it? thanks. "
We are having the same problem, and the posted work around does work:
"A possible workaround to this problem could be:
Please run "mmc /32 perfmon.msc" from Start-Run. Please let me know
whether
you can see the perfmon counters for 32-bit sql server or not. "
...But, that prevents us from being able to see the counters from our
own computers which makes troubleshooting emergencies much quicker than
having to log in to the server itself to perform this.
Does anyone know any way of being able to see these counters from a
remote computer?
Thanks.

Missing SQL perfmon counters in 2003 Cluster

Hi,
I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one
of the active server is missing the SQL performance counters, the weird
thing is, if I run Perfmon remotely connecting to this node, it will not
display any SQL Performance counters but if I login locally to the server
and run Perfmon, it will show the SQL performance counters.
Any idea why is this happening.
Thanks
Ayad
Permissions.
Try running the performance monitoring service using a real domain account
rather than the Network Service account.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:O59UFK28EHA.2572@.tk2msftngp13.phx.gbl...
> Hi,
> I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive),
one
> of the active server is missing the SQL performance counters, the weird
> thing is, if I run Perfmon remotely connecting to this node, it will not
> display any SQL Performance counters but if I login locally to the server
> and run Perfmon, it will show the SQL performance counters.
> Any idea why is this happening.
> Thanks
>
> Ayad
>

Missing performance counters on a W2K Server w/SQL Server 2000

Missing performance counters on a W2K Server w/SQL Server 2000Have a look here:
http://support.microsoft.com/default...&Product=sql2k
Andrew J. Kelly SQL MVP
"Elise" <anonymous@.discussions.microsoft.com> wrote in message
news:33bc01c4a272$9309a1f0$a601280a@.phx.gbl...
>
|||you can try this from the command prompt
unload first
unlodctr mssqlserver$virtualservername
then load
lodctr <\\virtualservername> g:\mssql7\binn\sqlctr.ini
or
lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"
I have seen this work without a sql server restart but ...
"Elise" wrote:

>

Missing performance counters on a W2K Server w/SQL Server 2000

Missing performance counters on a W2K Server w/SQL Server 2000Have a look here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
--
Andrew J. Kelly SQL MVP
"Elise" <anonymous@.discussions.microsoft.com> wrote in message
news:33bc01c4a272$9309a1f0$a601280a@.phx.gbl...
>|||you can try this from the command prompt
unload first
unlodctr mssqlserver$virtualservername
then load
lodctr <\\virtualservername> g:\mssql7\binn\sqlctr.ini
or
lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"
I have seen this work without a sql server restart but ...
"Elise" wrote:
>

Missing Performance Counters

I know that some of you have not only seen this happen, but have also
replied to similar posts. I have tried the whole unlodctr --> lodctr thing
several times and have read through MS documentation regarding possible
registry issues. I am at a standstill. Has anyone else been unsuccessful
in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
did you find a workaround? ThanksNot sure if this can help you :
http://www.extremeexperts.com/sql/faq/EnablingPerCounters.aspx
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Sean" <sdmgill@.hotmail.com> wrote in message
news:eAJpI1DmDHA.2000@.TK2MSFTNGP12.phx.gbl...
> I know that some of you have not only seen this happen, but have also
> replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> several times and have read through MS documentation regarding possible
> registry issues. I am at a standstill. Has anyone else been unsuccessful
> in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> did you find a workaround? Thanks
>|||Sean,
Do you see any error messages in the errorlog when starting sqlserver? Does
it say anyting about unable to allocate shared memory eraly on or doesn;t it
start the global collection task somehow?
--
regards,
Mario
http://www.sqlinternals.com
"Sean" <sdmgill@.hotmail.com> wrote in message
news:eAJpI1DmDHA.2000@.TK2MSFTNGP12.phx.gbl...
> I know that some of you have not only seen this happen, but have also
> replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> several times and have read through MS documentation regarding possible
> registry issues. I am at a standstill. Has anyone else been unsuccessful
> in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> did you find a workaround? Thanks
>|||On Tue, 21 Oct 2003 18:37:22 -0700, "Sean" <sdmgill@.hotmail.com>
wrote:
>I know that some of you have not only seen this happen, but have also
>replied to similar posts. I have tried the whole unlodctr --> lodctr thing
>several times and have read through MS documentation regarding possible
>registry issues. I am at a standstill. Has anyone else been unsuccessful
>in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
>did you find a workaround? Thanks
I just noticed something.
I have one copy of perfmon in my startup folder. I checked, and it
lacked the SQLServer counters.
I do not automatically start SQLServer on my workstation. I manually
started it, then started a second instance of perfmon. SQLServer
counters were there.
Your mileage may vary.
Joshua Stern|||But eh.., isn't that how it should work? If there's no sqlserver there are
no counters..
--
regards,
Mario
http://www.sqlinternals.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:301gpvodc69j5cmc3gvsg8fqm6agbl21om@.4ax.com...
> On Tue, 21 Oct 2003 18:37:22 -0700, "Sean" <sdmgill@.hotmail.com>
> wrote:
> >I know that some of you have not only seen this happen, but have also
> >replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> >several times and have read through MS documentation regarding possible
> >registry issues. I am at a standstill. Has anyone else been
unsuccessful
> >in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> >did you find a workaround? Thanks
> I just noticed something.
> I have one copy of perfmon in my startup folder. I checked, and it
> lacked the SQLServer counters.
> I do not automatically start SQLServer on my workstation. I manually
> started it, then started a second instance of perfmon. SQLServer
> counters were there.
> Your mileage may vary.
> Joshua Stern
>|||On Thu, 23 Oct 2003 18:48:09 +0200, "Mario" <nospam@.sqlinternals.com>
wrote:
>But eh.., isn't that how it should work? If there's no sqlserver there are
>no counters..
If you ask me, no, that is not how it should work.
Should be based more on what is installed, than on what it sees at
startup. After all, my first instance still didn't see the started
SQLServer. And if the server is remote, and not started, or gets
bounced, you get all kinds of interesting permutations. Etc.
J.|||I see your point. But anyway, that's how it works on my testserver too..
--
regards,
Mario
http://www.sqlinternals.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:tg4gpvk693u4dv5u16d9utlio884lg3fos@.4ax.com...
> On Thu, 23 Oct 2003 18:48:09 +0200, "Mario" <nospam@.sqlinternals.com>
> wrote:
> >But eh.., isn't that how it should work? If there's no sqlserver there
are
> >no counters..
> If you ask me, no, that is not how it should work.
> Should be based more on what is installed, than on what it sees at
> startup. After all, my first instance still didn't see the started
> SQLServer. And if the server is remote, and not started, or gets
> bounced, you get all kinds of interesting permutations. Etc.
> J.
>

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!
Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FA...rCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||See below URLS as well.
http://sql-server-performance.com/fo...p?TOPIC_ID=695
http://sql-server-performance.com/fo...p?TOPIC_ID=308
http://sql-server-performance.com/fo...p?TOPIC_ID=687
http://sql-server-performance.com/fo...p?TOPIC_ID=907
http://sql-server-performance.com/fo...p?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:

>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=695
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=308
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=687
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=907
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/F...erCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/f...sp?TOPIC_ID=695
http://sql-server-performance.com/f...sp?TOPIC_ID=308
http://sql-server-performance.com/f...sp?TOPIC_ID=687
http://sql-server-performance.com/f...sp?TOPIC_ID=907
http://sql-server-performance.com/f...sp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:

>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I canno
t
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>