Anyone got a copy?http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764568787.html
--
MICHAEL CARR
mcarr67@.email.uophx.edu
"John Cosmas" <vabo214@.msn.com> wrote in message
news:%23BOxHtTZEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Anyone got a copy?
>
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
production database down....hangs on startup..URGENT
I had a database hang earlier today and couldn't get it back. I tried to
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
Bruce
Sorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for that
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||... and SQL Server outputs progress report for the recovery phase in the error log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.com...
> news.microsoft.com wrote:
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...
|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
Bruce
Sorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for that
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||... and SQL Server outputs progress report for the recovery phase in the error log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.com...
> news.microsoft.com wrote:
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...
|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
production database down....hangs on startup..URGENT
I had a database hang earlier today and couldn't get it back. I tried to
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
BruceSorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for tha
t
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||... and SQL Server outputs progress report for the recovery phase in the er
ror log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.co
m...
> news.microsoft.com wrote:
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
BruceSorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for tha
t
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||... and SQL Server outputs progress report for the recovery phase in the er
ror log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.co
m...
> news.microsoft.com wrote:
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql
production database down....hangs on startup..URGENT
I had a database hang earlier today and couldn't get it back. I tried to
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
BruceSorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
>> I had a database hang earlier today and couldn't get it back. I tried to
>> stop and start the services but that hung too. Once I had ran out of
>> options, I rebooted the server (soft reboot). The services started
>> correctly and all the DB's looked ok...except one. I can't touch it in
>> anyway. I see there is a blocking process (under locks / process ID) but
>> it's a system process so I can't kill it.
>> I have no idea what to try. Can someone give me some help? Please?
>> Thanks for any info.
>> Bruce
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for that
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||... and SQL Server outputs progress report for the recovery phase in the error log file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.com...
> news.microsoft.com wrote:
>> Thanks for the reply. You're exactly right. I didn't check for blocking
>> before trying to restart the services. I would have waited, but I started
>> to panic when I couldn't even see the database. I see that it has blocks,
>> but when I try to select it in enterprise manager or query analyzer, the
>> client froze.
>> Since that has happened, I can't even see the SQL Server error log for that
>> DB. Should I just sit on it for now and wait for it to come back? Or are
>> there some tricks I can try to make sure all is ok and it's recovering
>> itself?
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...
>> news.microsoft.com wrote:
>> Thanks for the reply. You're exactly right. I didn't check for
>> blocking before trying to restart the services. I would have waited,
>> but I started to panic when I couldn't even see the database. I see
>> that it has blocks, but when I try to select it in enterprise manager or
>> query analyzer, the client froze.
>> Since that has happened, I can't even see the SQL Server error log for
>> that DB. Should I just sit on it for now and wait for it to come back?
>> Or are there some tricks I can try to make sure all is ok and it's
>> recovering itself?
>> You can (and should) view the error log using Notepad, it's found within
>> the MSSQL directory tree, or wherever SQL is installed. It's odd that
>> Enterprise Manager and QA both froze, the only time I've ever seen this
>> is on a development server that had the Auto-Close option enabled on the
>> databases.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
stop and start the services but that hung too. Once I had ran out of
options, I rebooted the server (soft reboot). The services started
correctly and all the DB's looked ok...except one. I can't touch it in
anyway. I see there is a blocking process (under locks / process ID) but
it's a system process so I can't kill it.
I have no idea what to try. Can someone give me some help? Please?
Thanks for any info.
BruceSorry, left out some info: we're running SQL 2000 on a Windows 2000 box.
Bruce
"news.microsoft.com" <sbthor69@.hotmail.com> wrote in message
news:%23FVG%23NI7GHA.2120@.TK2MSFTNGP03.phx.gbl...
>I had a database hang earlier today and couldn't get it back. I tried to
>stop and start the services but that hung too. Once I had ran out of
>options, I rebooted the server (soft reboot). The services started
>correctly and all the DB's looked ok...except one. I can't touch it in
>anyway. I see there is a blocking process (under locks / process ID) but
>it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>|||news.microsoft.com wrote:
> I had a database hang earlier today and couldn't get it back. I tried to
> stop and start the services but that hung too. Once I had ran out of
> options, I rebooted the server (soft reboot). The services started
> correctly and all the DB's looked ok...except one. I can't touch it in
> anyway. I see there is a blocking process (under locks / process ID) but
> it's a system process so I can't kill it.
> I have no idea what to try. Can someone give me some help? Please?
> Thanks for any info.
> Bruce
>
A database will rarely "hang", how did you determine that it was hung in
the first place? Did you check for blocking before doing anything else?
My guess is that there was a large transaction in progress that was
causing blocking, giving the appearance that the database was "hung".
Now that you've stopped/started/rebooted, SQL is "recovering" that
database, and is in the process of rolling back that large transaction.
If you look at the SQL Server error log, you will see messages about
recovery.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for the reply. You're exactly right. I didn't check for blocking
before trying to restart the services. I would have waited, but I started
to panic when I couldn't even see the database. I see that it has blocks,
but when I try to select it in enterprise manager or query analyzer, the
client froze.
Since that has happened, I can't even see the SQL Server error log for that
DB. Should I just sit on it for now and wait for it to come back? Or are
there some tricks I can try to make sure all is ok and it's recovering
itself?
Bruce
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452BC3AE.4040206@.realsqlguy.com...
> news.microsoft.com wrote:
>> I had a database hang earlier today and couldn't get it back. I tried to
>> stop and start the services but that hung too. Once I had ran out of
>> options, I rebooted the server (soft reboot). The services started
>> correctly and all the DB's looked ok...except one. I can't touch it in
>> anyway. I see there is a blocking process (under locks / process ID) but
>> it's a system process so I can't kill it.
>> I have no idea what to try. Can someone give me some help? Please?
>> Thanks for any info.
>> Bruce
> A database will rarely "hang", how did you determine that it was hung in
> the first place? Did you check for blocking before doing anything else?
> My guess is that there was a large transaction in progress that was
> causing blocking, giving the appearance that the database was "hung". Now
> that you've stopped/started/rebooted, SQL is "recovering" that database,
> and is in the process of rolling back that large transaction. If you look
> at the SQL Server error log, you will see messages about recovery.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the reply. You're exactly right. I didn't check for blocking
> before trying to restart the services. I would have waited, but I started
> to panic when I couldn't even see the database. I see that it has blocks,
> but when I try to select it in enterprise manager or query analyzer, the
> client froze.
> Since that has happened, I can't even see the SQL Server error log for that
> DB. Should I just sit on it for now and wait for it to come back? Or are
> there some tricks I can try to make sure all is ok and it's recovering
> itself?
You can (and should) view the error log using Notepad, it's found within
the MSSQL directory tree, or wherever SQL is installed. It's odd that
Enterprise Manager and QA both froze, the only time I've ever seen this
is on a development server that had the Auto-Close option enabled on the
databases.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||... and SQL Server outputs progress report for the recovery phase in the error log file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:452BC644.3020804@.realsqlguy.com...
> news.microsoft.com wrote:
>> Thanks for the reply. You're exactly right. I didn't check for blocking
>> before trying to restart the services. I would have waited, but I started
>> to panic when I couldn't even see the database. I see that it has blocks,
>> but when I try to select it in enterprise manager or query analyzer, the
>> client froze.
>> Since that has happened, I can't even see the SQL Server error log for that
>> DB. Should I just sit on it for now and wait for it to come back? Or are
>> there some tricks I can try to make sure all is ok and it's recovering
>> itself?
> You can (and should) view the error log using Notepad, it's found within
> the MSSQL directory tree, or wherever SQL is installed. It's odd that
> Enterprise Manager and QA both froze, the only time I've ever seen this
> is on a development server that had the Auto-Close option enabled on the
> databases.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for the help. You guys were right on target. The log file showed
the recovery process for the DB in question. After Tracy told me to wait
patiently (and I did), it recovered successfully.
Thanks again.
Bruce
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uk8K1gI7GHA.4232@.TK2MSFTNGP02.phx.gbl...
> ... and SQL Server outputs progress report for the recovery phase in the
> error log file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:452BC644.3020804@.realsqlguy.com...
>> news.microsoft.com wrote:
>> Thanks for the reply. You're exactly right. I didn't check for
>> blocking before trying to restart the services. I would have waited,
>> but I started to panic when I couldn't even see the database. I see
>> that it has blocks, but when I try to select it in enterprise manager or
>> query analyzer, the client froze.
>> Since that has happened, I can't even see the SQL Server error log for
>> that DB. Should I just sit on it for now and wait for it to come back?
>> Or are there some tricks I can try to make sure all is ok and it's
>> recovering itself?
>> You can (and should) view the error log using Notepad, it's found within
>> the MSSQL directory tree, or wherever SQL is installed. It's odd that
>> Enterprise Manager and QA both froze, the only time I've ever seen this
>> is on a development server that had the Auto-Close option enabled on the
>> databases.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com|||news.microsoft.com wrote:
> Thanks for the help. You guys were right on target. The log file showed
> the recovery process for the DB in question. After Tracy told me to wait
> patiently (and I did), it recovered successfully.
>
FYI, if this happens again, where the server appears to "hang", check
for blocking. It is extremely rare that you should have to reboot the
server like this. Look for a process that is blocking others, determine
what that process is doing, and use KILL to terminate it if necessary.
This will stop the process and rollback (this may take a while) the
changes that it made. This rollback is the same process that you just
witnessed. Read about the KILL command in Books Online to understand
the implications of using it...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Product Version query
I've just downloaded SQL Server Express (with advanced services) from both the main SQL Server Express website and from MSDN. When I right click on the exe I downloaded and go into properties the Product Version says SQLEVALVER. To me this implies it is an evaluation.
Can I confirm this is just a mistake and if we start to redistribute the product it won't timeout in the future? I am sure it is not an evaluation but just want to make absolutely sure.
hi,
, yep... it's true ...
but as long as you downloaded the correct binaries there's no problem, and it will install the appropriate SQLExpress version..
and this are not Eval binaries... they are just "free"..
regards
Product Key for MSDN - SQL Reporting
We have MSDN CD with SQL Reporting services 2000 on it. However, we do not
have any CD key with it. Also, there is no file in the CD which states the
product key. Where can we get it from?
Thanks in advanceI'm trying to remember but I don't think it has a key with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepti Hait" <Deepti Hait@.discussions.microsoft.com> wrote in message
news:B0619563-472E-467A-B70A-0C31A3A68219@.microsoft.com...
> We have MSDN CD with SQL Reporting services 2000 on it. However, we do not
> have any CD key with it. Also, there is no file in the CD which states the
> product key. Where can we get it from?
> Thanks in advance
have any CD key with it. Also, there is no file in the CD which states the
product key. Where can we get it from?
Thanks in advanceI'm trying to remember but I don't think it has a key with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepti Hait" <Deepti Hait@.discussions.microsoft.com> wrote in message
news:B0619563-472E-467A-B70A-0C31A3A68219@.microsoft.com...
> We have MSDN CD with SQL Reporting services 2000 on it. However, we do not
> have any CD key with it. Also, there is no file in the CD which states the
> product key. Where can we get it from?
> Thanks in advance
Producing reports on a web page
Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
reading up on MS SQL Reporting Services and from what I can see they offer a
report repository as well as a a web based portal for downloading the reports.
The company I work for is currently using the following:
â?¢ Webserver running IIS
â?¢ SQL Server 2000
â?¢ Coldfusion MX 7.0 Server
â?¢ Crystal Enterprise Server 10.0
The current set-up we have is to produce the report in a web page (not
necessarily through a proprietary portal or anything like that).
Crystal Reports no longer supports this functionality in version 11. Does
anyone here know if it's possible for me to be able to create and produce a
report and then display it on a web page using Cold Fusion? This would
include being able to create a subreport and passing it parameters with
stored procedures.
Thanks!
ToddNot sure how Cold Fusion works but there are two ways you can integrate with
Report Services (assuming you are not using the Portal it ships with). One
is to use URL integration and the other is web services. With VS 2005 there
are two new controls (webform and winform) that integrate with RS 2005 using
webservices. Very good and very tight integration. They require 2.0
framework.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> reading up on MS SQL Reporting Services and from what I can see they offer
> a
> report repository as well as a a web based portal for downloading the
> reports.
> The company I work for is currently using the following:
> . Webserver running IIS
> . SQL Server 2000
> . Coldfusion MX 7.0 Server
> . Crystal Enterprise Server 10.0
> The current set-up we have is to produce the report in a web page (not
> necessarily through a proprietary portal or anything like that).
> Crystal Reports no longer supports this functionality in version 11. Does
> anyone here know if it's possible for me to be able to create and produce
> a
> report and then display it on a web page using Cold Fusion? This would
> include being able to create a subreport and passing it parameters with
> stored procedures.
>
> Thanks!
> Todd|||Thanks Bruce, I really appreciate the response.
This is how they currently do it:
Can you tell me if it is at all possible to do this with Microsoft Reporting
services? They are asking me to do the research and find out if MS SQL is a
viable solution.
-----
This document has been created demonstrating how we use Crystal Reports in
real life for reporting. It would be great if Cold Fusion reports could
produce the same result in the near future. Not only would it relive us of
many yearly fees from Business Objects, but it would rededicate our future to
ColdFusion and Macromedia/Adobe.
We currently use Crystal Reports Developer 10 and XI to develop reports that
get generated and displayed in our software on the fly. This software is
driven by ColdFusion MX 7.0. The reports are built upon stored procedures
that accept variables and produce different results.
Crystal Developer lets you browse the available stored procedures and select
the one you would like to use:
After you select which stored procedure you would like to use, the next
screen automatically asks you for some sample data to pass to the SP
variables:
Once the report has been attached to the stored procedure, the rest is just
creating the report. The field explorer on the shows which fields are
available from the stored procedure:
Fields are dragged on and the report is saved. Displaying the report can be
done by using some simple javascript. So we have the flexibility to have
whatever we want on the screen, and the report to be â'embeddedâ' in our
application.
We created a header and a footer to wrap around the parameters because those
donâ't change.
In our attempts to move over to the early version of ColdFusion reports,
this process has been real clumsy. The stored procedures donâ't show up on
the database browser and the only way we can get them to execute is using the
exec <stored procedure> in the query window. You can forget about passing
variables to it. It would be great if a similar process could be duplicated
with ColdFusion reports.
Thanks!!!
Todd
"Bruce L-C [MVP]" wrote:
> Not sure how Cold Fusion works but there are two ways you can integrate with
> Report Services (assuming you are not using the Portal it ships with). One
> is to use URL integration and the other is web services. With VS 2005 there
> are two new controls (webform and winform) that integrate with RS 2005 using
> webservices. Very good and very tight integration. They require 2.0
> framework.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
> news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> > reading up on MS SQL Reporting Services and from what I can see they offer
> > a
> > report repository as well as a a web based portal for downloading the
> > reports.
> >
> > The company I work for is currently using the following:
> >
> > . Webserver running IIS
> > . SQL Server 2000
> > . Coldfusion MX 7.0 Server
> > . Crystal Enterprise Server 10.0
> >
> > The current set-up we have is to produce the report in a web page (not
> > necessarily through a proprietary portal or anything like that).
> >
> > Crystal Reports no longer supports this functionality in version 11. Does
> > anyone here know if it's possible for me to be able to create and produce
> > a
> > report and then display it on a web page using Cold Fusion? This would
> > include being able to create a subreport and passing it parameters with
> > stored procedures.
> >
> >
> > Thanks!
> >
> > Todd
>
>|||The process here is just how the report is created by the developer? I.e.
this is not happening by an end user is it?
What you would do with RS is to create the report using your stored
procedures. SP are fully supported as long as the SP returns a single
resultset. Multiple resultsets are not supported. Once you have the report
working then you use either URL integration or webservices and integrate it
with your web pages.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Todd Jaspers" <ToddJaspers@.discussions.microsoft.com> wrote in message
news:8E94C9CC-0C74-4F60-AA08-C02CA08C71DB@.microsoft.com...
> Thanks Bruce, I really appreciate the response.
> This is how they currently do it:
> Can you tell me if it is at all possible to do this with Microsoft
> Reporting
> services? They are asking me to do the research and find out if MS SQL is
> a
> viable solution.
>
> -----
> This document has been created demonstrating how we use Crystal Reports in
> real life for reporting. It would be great if Cold Fusion reports could
> produce the same result in the near future. Not only would it relive us
> of
> many yearly fees from Business Objects, but it would rededicate our future
> to
> ColdFusion and Macromedia/Adobe.
> We currently use Crystal Reports Developer 10 and XI to develop reports
> that
> get generated and displayed in our software on the fly. This software is
> driven by ColdFusion MX 7.0. The reports are built upon stored procedures
> that accept variables and produce different results.
> Crystal Developer lets you browse the available stored procedures and
> select
> the one you would like to use:
> After you select which stored procedure you would like to use, the next
> screen automatically asks you for some sample data to pass to the SP
> variables:
> Once the report has been attached to the stored procedure, the rest is
> just
> creating the report. The field explorer on the shows which fields are
> available from the stored procedure:
> Fields are dragged on and the report is saved. Displaying the report can
> be
> done by using some simple javascript. So we have the flexibility to have
> whatever we want on the screen, and the report to be "embedded" in our
> application.
> We created a header and a footer to wrap around the parameters because
> those
> don't change.
> In our attempts to move over to the early version of ColdFusion reports,
> this process has been real clumsy. The stored procedures don't show up on
> the database browser and the only way we can get them to execute is using
> the
> exec <stored procedure> in the query window. You can forget about passing
> variables to it. It would be great if a similar process could be
> duplicated
> with ColdFusion reports.
>
> Thanks!!!
> Todd
>
> "Bruce L-C [MVP]" wrote:
>> Not sure how Cold Fusion works but there are two ways you can integrate
>> with
>> Report Services (assuming you are not using the Portal it ships with).
>> One
>> is to use URL integration and the other is web services. With VS 2005
>> there
>> are two new controls (webform and winform) that integrate with RS 2005
>> using
>> webservices. Very good and very tight integration. They require 2.0
>> framework.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
>> news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
>> > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've
>> > been
>> > reading up on MS SQL Reporting Services and from what I can see they
>> > offer
>> > a
>> > report repository as well as a a web based portal for downloading the
>> > reports.
>> >
>> > The company I work for is currently using the following:
>> >
>> > . Webserver running IIS
>> > . SQL Server 2000
>> > . Coldfusion MX 7.0 Server
>> > . Crystal Enterprise Server 10.0
>> >
>> > The current set-up we have is to produce the report in a web page (not
>> > necessarily through a proprietary portal or anything like that).
>> >
>> > Crystal Reports no longer supports this functionality in version 11.
>> > Does
>> > anyone here know if it's possible for me to be able to create and
>> > produce
>> > a
>> > report and then display it on a web page using Cold Fusion? This would
>> > include being able to create a subreport and passing it parameters with
>> > stored procedures.
>> >
>> >
>> > Thanks!
>> >
>> > Todd
>>|||Hi Todd,
I assume you know Cold fussion ? Does cold fusion, uses web services,
if yes, you can easily..integrate the way of reporting services or crystal
report
to be see in ur portal.
Why crystal report is not supported in the web in Version 11'who said this
regards
"Todd Jaspers" wrote:
> Thanks Bruce, I really appreciate the response.
> This is how they currently do it:
> Can you tell me if it is at all possible to do this with Microsoft Reporting
> services? They are asking me to do the research and find out if MS SQL is a
> viable solution.
>
> -----
> This document has been created demonstrating how we use Crystal Reports in
> real life for reporting. It would be great if Cold Fusion reports could
> produce the same result in the near future. Not only would it relive us of
> many yearly fees from Business Objects, but it would rededicate our future to
> ColdFusion and Macromedia/Adobe.
> We currently use Crystal Reports Developer 10 and XI to develop reports that
> get generated and displayed in our software on the fly. This software is
> driven by ColdFusion MX 7.0. The reports are built upon stored procedures
> that accept variables and produce different results.
> Crystal Developer lets you browse the available stored procedures and select
> the one you would like to use:
> After you select which stored procedure you would like to use, the next
> screen automatically asks you for some sample data to pass to the SP
> variables:
> Once the report has been attached to the stored procedure, the rest is just
> creating the report. The field explorer on the shows which fields are
> available from the stored procedure:
> Fields are dragged on and the report is saved. Displaying the report can be
> done by using some simple javascript. So we have the flexibility to have
> whatever we want on the screen, and the report to be â'embeddedâ' in our
> application.
> We created a header and a footer to wrap around the parameters because those
> donâ't change.
> In our attempts to move over to the early version of ColdFusion reports,
> this process has been real clumsy. The stored procedures donâ't show up on
> the database browser and the only way we can get them to execute is using the
> exec <stored procedure> in the query window. You can forget about passing
> variables to it. It would be great if a similar process could be duplicated
> with ColdFusion reports.
>
> Thanks!!!
> Todd
>
> "Bruce L-C [MVP]" wrote:
> > Not sure how Cold Fusion works but there are two ways you can integrate with
> > Report Services (assuming you are not using the Portal it ships with). One
> > is to use URL integration and the other is web services. With VS 2005 there
> > are two new controls (webform and winform) that integrate with RS 2005 using
> > webservices. Very good and very tight integration. They require 2.0
> > framework.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
> > news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> > > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> > > reading up on MS SQL Reporting Services and from what I can see they offer
> > > a
> > > report repository as well as a a web based portal for downloading the
> > > reports.
> > >
> > > The company I work for is currently using the following:
> > >
> > > . Webserver running IIS
> > > . SQL Server 2000
> > > . Coldfusion MX 7.0 Server
> > > . Crystal Enterprise Server 10.0
> > >
> > > The current set-up we have is to produce the report in a web page (not
> > > necessarily through a proprietary portal or anything like that).
> > >
> > > Crystal Reports no longer supports this functionality in version 11. Does
> > > anyone here know if it's possible for me to be able to create and produce
> > > a
> > > report and then display it on a web page using Cold Fusion? This would
> > > include being able to create a subreport and passing it parameters with
> > > stored procedures.
> > >
> > >
> > > Thanks!
> > >
> > > Todd
> >
> >
> >
reading up on MS SQL Reporting Services and from what I can see they offer a
report repository as well as a a web based portal for downloading the reports.
The company I work for is currently using the following:
â?¢ Webserver running IIS
â?¢ SQL Server 2000
â?¢ Coldfusion MX 7.0 Server
â?¢ Crystal Enterprise Server 10.0
The current set-up we have is to produce the report in a web page (not
necessarily through a proprietary portal or anything like that).
Crystal Reports no longer supports this functionality in version 11. Does
anyone here know if it's possible for me to be able to create and produce a
report and then display it on a web page using Cold Fusion? This would
include being able to create a subreport and passing it parameters with
stored procedures.
Thanks!
ToddNot sure how Cold Fusion works but there are two ways you can integrate with
Report Services (assuming you are not using the Portal it ships with). One
is to use URL integration and the other is web services. With VS 2005 there
are two new controls (webform and winform) that integrate with RS 2005 using
webservices. Very good and very tight integration. They require 2.0
framework.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> reading up on MS SQL Reporting Services and from what I can see they offer
> a
> report repository as well as a a web based portal for downloading the
> reports.
> The company I work for is currently using the following:
> . Webserver running IIS
> . SQL Server 2000
> . Coldfusion MX 7.0 Server
> . Crystal Enterprise Server 10.0
> The current set-up we have is to produce the report in a web page (not
> necessarily through a proprietary portal or anything like that).
> Crystal Reports no longer supports this functionality in version 11. Does
> anyone here know if it's possible for me to be able to create and produce
> a
> report and then display it on a web page using Cold Fusion? This would
> include being able to create a subreport and passing it parameters with
> stored procedures.
>
> Thanks!
> Todd|||Thanks Bruce, I really appreciate the response.
This is how they currently do it:
Can you tell me if it is at all possible to do this with Microsoft Reporting
services? They are asking me to do the research and find out if MS SQL is a
viable solution.
-----
This document has been created demonstrating how we use Crystal Reports in
real life for reporting. It would be great if Cold Fusion reports could
produce the same result in the near future. Not only would it relive us of
many yearly fees from Business Objects, but it would rededicate our future to
ColdFusion and Macromedia/Adobe.
We currently use Crystal Reports Developer 10 and XI to develop reports that
get generated and displayed in our software on the fly. This software is
driven by ColdFusion MX 7.0. The reports are built upon stored procedures
that accept variables and produce different results.
Crystal Developer lets you browse the available stored procedures and select
the one you would like to use:
After you select which stored procedure you would like to use, the next
screen automatically asks you for some sample data to pass to the SP
variables:
Once the report has been attached to the stored procedure, the rest is just
creating the report. The field explorer on the shows which fields are
available from the stored procedure:
Fields are dragged on and the report is saved. Displaying the report can be
done by using some simple javascript. So we have the flexibility to have
whatever we want on the screen, and the report to be â'embeddedâ' in our
application.
We created a header and a footer to wrap around the parameters because those
donâ't change.
In our attempts to move over to the early version of ColdFusion reports,
this process has been real clumsy. The stored procedures donâ't show up on
the database browser and the only way we can get them to execute is using the
exec <stored procedure> in the query window. You can forget about passing
variables to it. It would be great if a similar process could be duplicated
with ColdFusion reports.
Thanks!!!
Todd
"Bruce L-C [MVP]" wrote:
> Not sure how Cold Fusion works but there are two ways you can integrate with
> Report Services (assuming you are not using the Portal it ships with). One
> is to use URL integration and the other is web services. With VS 2005 there
> are two new controls (webform and winform) that integrate with RS 2005 using
> webservices. Very good and very tight integration. They require 2.0
> framework.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
> news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> > reading up on MS SQL Reporting Services and from what I can see they offer
> > a
> > report repository as well as a a web based portal for downloading the
> > reports.
> >
> > The company I work for is currently using the following:
> >
> > . Webserver running IIS
> > . SQL Server 2000
> > . Coldfusion MX 7.0 Server
> > . Crystal Enterprise Server 10.0
> >
> > The current set-up we have is to produce the report in a web page (not
> > necessarily through a proprietary portal or anything like that).
> >
> > Crystal Reports no longer supports this functionality in version 11. Does
> > anyone here know if it's possible for me to be able to create and produce
> > a
> > report and then display it on a web page using Cold Fusion? This would
> > include being able to create a subreport and passing it parameters with
> > stored procedures.
> >
> >
> > Thanks!
> >
> > Todd
>
>|||The process here is just how the report is created by the developer? I.e.
this is not happening by an end user is it?
What you would do with RS is to create the report using your stored
procedures. SP are fully supported as long as the SP returns a single
resultset. Multiple resultsets are not supported. Once you have the report
working then you use either URL integration or webservices and integrate it
with your web pages.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Todd Jaspers" <ToddJaspers@.discussions.microsoft.com> wrote in message
news:8E94C9CC-0C74-4F60-AA08-C02CA08C71DB@.microsoft.com...
> Thanks Bruce, I really appreciate the response.
> This is how they currently do it:
> Can you tell me if it is at all possible to do this with Microsoft
> Reporting
> services? They are asking me to do the research and find out if MS SQL is
> a
> viable solution.
>
> -----
> This document has been created demonstrating how we use Crystal Reports in
> real life for reporting. It would be great if Cold Fusion reports could
> produce the same result in the near future. Not only would it relive us
> of
> many yearly fees from Business Objects, but it would rededicate our future
> to
> ColdFusion and Macromedia/Adobe.
> We currently use Crystal Reports Developer 10 and XI to develop reports
> that
> get generated and displayed in our software on the fly. This software is
> driven by ColdFusion MX 7.0. The reports are built upon stored procedures
> that accept variables and produce different results.
> Crystal Developer lets you browse the available stored procedures and
> select
> the one you would like to use:
> After you select which stored procedure you would like to use, the next
> screen automatically asks you for some sample data to pass to the SP
> variables:
> Once the report has been attached to the stored procedure, the rest is
> just
> creating the report. The field explorer on the shows which fields are
> available from the stored procedure:
> Fields are dragged on and the report is saved. Displaying the report can
> be
> done by using some simple javascript. So we have the flexibility to have
> whatever we want on the screen, and the report to be "embedded" in our
> application.
> We created a header and a footer to wrap around the parameters because
> those
> don't change.
> In our attempts to move over to the early version of ColdFusion reports,
> this process has been real clumsy. The stored procedures don't show up on
> the database browser and the only way we can get them to execute is using
> the
> exec <stored procedure> in the query window. You can forget about passing
> variables to it. It would be great if a similar process could be
> duplicated
> with ColdFusion reports.
>
> Thanks!!!
> Todd
>
> "Bruce L-C [MVP]" wrote:
>> Not sure how Cold Fusion works but there are two ways you can integrate
>> with
>> Report Services (assuming you are not using the Portal it ships with).
>> One
>> is to use URL integration and the other is web services. With VS 2005
>> there
>> are two new controls (webform and winform) that integrate with RS 2005
>> using
>> webservices. Very good and very tight integration. They require 2.0
>> framework.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
>> news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
>> > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've
>> > been
>> > reading up on MS SQL Reporting Services and from what I can see they
>> > offer
>> > a
>> > report repository as well as a a web based portal for downloading the
>> > reports.
>> >
>> > The company I work for is currently using the following:
>> >
>> > . Webserver running IIS
>> > . SQL Server 2000
>> > . Coldfusion MX 7.0 Server
>> > . Crystal Enterprise Server 10.0
>> >
>> > The current set-up we have is to produce the report in a web page (not
>> > necessarily through a proprietary portal or anything like that).
>> >
>> > Crystal Reports no longer supports this functionality in version 11.
>> > Does
>> > anyone here know if it's possible for me to be able to create and
>> > produce
>> > a
>> > report and then display it on a web page using Cold Fusion? This would
>> > include being able to create a subreport and passing it parameters with
>> > stored procedures.
>> >
>> >
>> > Thanks!
>> >
>> > Todd
>>|||Hi Todd,
I assume you know Cold fussion ? Does cold fusion, uses web services,
if yes, you can easily..integrate the way of reporting services or crystal
report
to be see in ur portal.
Why crystal report is not supported in the web in Version 11'who said this
regards
"Todd Jaspers" wrote:
> Thanks Bruce, I really appreciate the response.
> This is how they currently do it:
> Can you tell me if it is at all possible to do this with Microsoft Reporting
> services? They are asking me to do the research and find out if MS SQL is a
> viable solution.
>
> -----
> This document has been created demonstrating how we use Crystal Reports in
> real life for reporting. It would be great if Cold Fusion reports could
> produce the same result in the near future. Not only would it relive us of
> many yearly fees from Business Objects, but it would rededicate our future to
> ColdFusion and Macromedia/Adobe.
> We currently use Crystal Reports Developer 10 and XI to develop reports that
> get generated and displayed in our software on the fly. This software is
> driven by ColdFusion MX 7.0. The reports are built upon stored procedures
> that accept variables and produce different results.
> Crystal Developer lets you browse the available stored procedures and select
> the one you would like to use:
> After you select which stored procedure you would like to use, the next
> screen automatically asks you for some sample data to pass to the SP
> variables:
> Once the report has been attached to the stored procedure, the rest is just
> creating the report. The field explorer on the shows which fields are
> available from the stored procedure:
> Fields are dragged on and the report is saved. Displaying the report can be
> done by using some simple javascript. So we have the flexibility to have
> whatever we want on the screen, and the report to be â'embeddedâ' in our
> application.
> We created a header and a footer to wrap around the parameters because those
> donâ't change.
> In our attempts to move over to the early version of ColdFusion reports,
> this process has been real clumsy. The stored procedures donâ't show up on
> the database browser and the only way we can get them to execute is using the
> exec <stored procedure> in the query window. You can forget about passing
> variables to it. It would be great if a similar process could be duplicated
> with ColdFusion reports.
>
> Thanks!!!
> Todd
>
> "Bruce L-C [MVP]" wrote:
> > Not sure how Cold Fusion works but there are two ways you can integrate with
> > Report Services (assuming you are not using the Portal it ships with). One
> > is to use URL integration and the other is web services. With VS 2005 there
> > are two new controls (webform and winform) that integrate with RS 2005 using
> > webservices. Very good and very tight integration. They require 2.0
> > framework.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Todd Jaspers" <Todd Jaspers@.discussions.microsoft.com> wrote in message
> > news:058E4F12-E1DF-4409-AA42-9215BF1F578D@.microsoft.com...
> > > Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been
> > > reading up on MS SQL Reporting Services and from what I can see they offer
> > > a
> > > report repository as well as a a web based portal for downloading the
> > > reports.
> > >
> > > The company I work for is currently using the following:
> > >
> > > . Webserver running IIS
> > > . SQL Server 2000
> > > . Coldfusion MX 7.0 Server
> > > . Crystal Enterprise Server 10.0
> > >
> > > The current set-up we have is to produce the report in a web page (not
> > > necessarily through a proprietary portal or anything like that).
> > >
> > > Crystal Reports no longer supports this functionality in version 11. Does
> > > anyone here know if it's possible for me to be able to create and produce
> > > a
> > > report and then display it on a web page using Cold Fusion? This would
> > > include being able to create a subreport and passing it parameters with
> > > stored procedures.
> > >
> > >
> > > Thanks!
> > >
> > > Todd
> >
> >
> >
Friday, March 23, 2012
ProClarity Expert Needed for our BI Team - Texas Job Opportunity
Hi All,
We are starting on a tool called Proclarity, which is used on top of Microsoft SQL Server Analysis Services. Having this as the basic idea, I’m not clear on some information as listed below: Any clarification would be very helpful.
1 Having SSRS (SQL Server Reporting Service) available to perform reports, what is Proclarity for Reporting Services. What it does by integrating with SSRS and its advantages. How is it different from Proclarity Web/Desktop professional.
2 Having Business Scorecard manager from Microsoft, what is the purpose of Proclarity KPI Designer, its advantages/disadvantages over BSM? Still proclarity has one more add-on Proclarity for BSM (not sure why we need this)
3 Proclarity Selector – Purpose of this tool?
4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.
Regards, Kart
Hello!
1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.
2. The KPI-designer is a tool for building and saving KPI:s in ProClarity Analytics server. Its main use is to build KPI:s on top of SSAS2005 cubes. Business scorecard manager is a tool for building balanced scorecards. The main difference is that BSM can use weights for KPI:s and also create hierarchies for KPI:s. BSM can do this with more data sources than ProClarity.
3. This tool helps you with building named sets, like the top 10 best selling products.
4. PDS is a dashboard server. Sharepoint can do a little more than that. The main advantage with PDS is that it is easy to create and visualize KPI:s from Analytics server, without having to write MDX.
HTH
Thomas Ivarsson
|||Hi Thomas,
Thanks for the Info.
1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.
2. When you say BSM can create Hierarchies for KPIs, it is like by adding a KPI to scorecard and adding Row Members (in scorecard view). Is my understanding correct. Doesn't this come automatically in proclarify when we define a KPI using a measure - because the we would have defined hierarchies in cube itself.
3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer
4. Got it.
Regards, kart
|||
1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.
2. This is from memory, but in BSM you create objectives and place one or serveral KPI:s in that objective. This objective is a KPI that is defined by the KPI:s mapped to it. In ProClarity and SSAS2005(the KPI-tab) the KPI:s you define are not presented in hierarchies but flat. Measures do not have hierarchies in SSAS2005.
3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.
Regards
Thomas Ivarsson
|||Hi Thomas,
Thanks again and I got good clarity on Proclarity now.
2. Can I conclude like -KPI definition through BSM is better than doing the same using Proclarity KPI Designer and Defining KPI in the Cube itself. (But, still go ahed using Proclarity for Detailed analysis of any value that is defined by KPI)
Regards, Kart
|||Hi,
In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.
BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.
However, if the source for the KPI data is SSAS, I will define the KPI at SSAS, making it centrally managed and reusable in other places (like SSRS), and import the KPI tp BSM (using the KPIUtil tool).
HTH,
Jordi Rambla
Solid Quality Learning
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||Hello Jordi,
I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
Proclarity and SQL Server 2005
Hi All,
We are starting on a tool called Proclarity, which is used on top of Microsoft SQL Server Analysis Services. Having this as the basic idea, I’m not clear on some information as listed below: Any clarification would be very helpful.
1 Having SSRS (SQL Server Reporting Service) available to perform reports, what is Proclarity for Reporting Services. What it does by integrating with SSRS and its advantages. How is it different from Proclarity Web/Desktop professional.
2 Having Business Scorecard manager from Microsoft, what is the purpose of Proclarity KPI Designer, its advantages/disadvantages over BSM? Still proclarity has one more add-on Proclarity for BSM (not sure why we need this)
3 Proclarity Selector – Purpose of this tool?
4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.
Regards, Kart
Hello!
1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.
2. The KPI-designer is a tool for building and saving KPI:s in ProClarity Analytics server. Its main use is to build KPI:s on top of SSAS2005 cubes. Business scorecard manager is a tool for building balanced scorecards. The main difference is that BSM can use weights for KPI:s and also create hierarchies for KPI:s. BSM can do this with more data sources than ProClarity.
3. This tool helps you with building named sets, like the top 10 best selling products.
4. PDS is a dashboard server. Sharepoint can do a little more than that. The main advantage with PDS is that it is easy to create and visualize KPI:s from Analytics server, without having to write MDX.
HTH
Thomas Ivarsson
|||Hi Thomas,
Thanks for the Info.
1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.
2. When you say BSM can create Hierarchies for KPIs, it is like by adding a KPI to scorecard and adding Row Members (in scorecard view). Is my understanding correct. Doesn't this come automatically in proclarify when we define a KPI using a measure - because the we would have defined hierarchies in cube itself.
3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer
4. Got it.
Regards, kart
|||
1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.
2. This is from memory, but in BSM you create objectives and place one or serveral KPI:s in that objective. This objective is a KPI that is defined by the KPI:s mapped to it. In ProClarity and SSAS2005(the KPI-tab) the KPI:s you define are not presented in hierarchies but flat. Measures do not have hierarchies in SSAS2005.
3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.
Regards
Thomas Ivarsson
|||Hi Thomas,
Thanks again and I got good clarity on Proclarity now.
2. Can I conclude like -KPI definition through BSM is better than doing the same using Proclarity KPI Designer and Defining KPI in the Cube itself. (But, still go ahed using Proclarity for Detailed analysis of any value that is defined by KPI)
Regards, Kart
|||Hi,
In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.
BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.
However, if the source for the KPI data is SSAS, I will define the KPI at SSAS, making it centrally managed and reusable in other places (like SSRS), and import the KPI tp BSM (using the KPIUtil tool).
HTH,
Jordi Rambla
Solid Quality Learning
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||Hello Jordi,
I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
Proclarity and SQL Server 2005
Hi All,
We are starting on a tool called Proclarity, which is used on top of Microsoft SQL Server Analysis Services. Having this as the basic idea, I’m not clear on some information as listed below: Any clarification would be very helpful.
1 Having SSRS (SQL Server Reporting Service) available to perform reports, what is Proclarity for Reporting Services. What it does by integrating with SSRS and its advantages. How is it different from Proclarity Web/Desktop professional.
2 Having Business Scorecard manager from Microsoft, what is the purpose of Proclarity KPI Designer, its advantages/disadvantages over BSM? Still proclarity has one more add-on Proclarity for BSM (not sure why we need this)
3 Proclarity Selector – Purpose of this tool?
4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.
Regards, Kart
Hello!
1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.
2. The KPI-designer is a tool for building and saving KPI:s in ProClarity Analytics server. Its main use is to build KPI:s on top of SSAS2005 cubes. Business scorecard manager is a tool for building balanced scorecards. The main difference is that BSM can use weights for KPI:s and also create hierarchies for KPI:s. BSM can do this with more data sources than ProClarity.
3. This tool helps you with building named sets, like the top 10 best selling products.
4. PDS is a dashboard server. Sharepoint can do a little more than that. The main advantage with PDS is that it is easy to create and visualize KPI:s from Analytics server, without having to write MDX.
HTH
Thomas Ivarsson
|||Hi Thomas,
Thanks for the Info.
1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.
2. When you say BSM can create Hierarchies for KPIs, it is like by adding a KPI to scorecard and adding Row Members (in scorecard view). Is my understanding correct. Doesn't this come automatically in proclarify when we define a KPI using a measure - because the we would have defined hierarchies in cube itself.
3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer
4. Got it.
Regards, kart
|||
1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.
2. This is from memory, but in BSM you create objectives and place one or serveral KPI:s in that objective. This objective is a KPI that is defined by the KPI:s mapped to it. In ProClarity and SSAS2005(the KPI-tab) the KPI:s you define are not presented in hierarchies but flat. Measures do not have hierarchies in SSAS2005.
3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.
Regards
Thomas Ivarsson
|||Hi Thomas,
Thanks again and I got good clarity on Proclarity now.
2. Can I conclude like -KPI definition through BSM is better than doing the same using Proclarity KPI Designer and Defining KPI in the Cube itself. (But, still go ahed using Proclarity for Detailed analysis of any value that is defined by KPI)
Regards, Kart
|||Hi,
In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.
BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.
However, if the source for the KPI data is SSAS, I will define the KPI at SSAS, making it centrally managed and reusable in other places (like SSRS), and import the KPI tp BSM (using the KPIUtil tool).
HTH,
Jordi Rambla
Solid Quality Learning
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
|||Hello Jordi,
I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.
Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.
If hired fulltime, we pay you $500 for any referrals that are hired.
I hope to hear from you soon!
Best Regards,
Lynsey Moore
Lynsey Moore
Recruiting Specialist
713.395.7150 | Phone
713.395-7130 | Fax
www.catapultsystems.com
CATAPULT SYSTEMS INC.
ENABLING BUSINESS THROUGH TECHNOLOGY
Proclarity
I log into a terminal services machine using domain\userid. When I try to connect to Proclarity it prompts me to log in again. I re-enter domain\userid and Proclarity connects to the AS cubes.
Is there an authentication problem with terminal services and the Proclarity client?
If you are using the professional, windows, client you should be able to only enter the server name, when promted at logon. If you use webaccess with a browser or connect with the windows client by using http, you can be promted for login information. Probably you have a webserver that uses basic authentication.
I use TS with ProClarity Professional(installed on the server) daily without any login requirements.
Regards
Thomas Ivarsson
|||It think it can also depend if you have proclarity and AS on two machines, I'm required to logon to both proclarity and the AS cubes when using the professional product, although this is the web prefessional product.|||Everyone is on the right path here. ProClarity has three different "client" tools:
ProClarity Standard - Thin client requiring no client install accessed through the ProClarity Analytics Server (PAS) URL
ProClarity Web Professional - COM components required on client. User must access PAS to retrieve a Briefing Book. After a Briefing Book is retrieved from PAS this client operates exactly like ProClarity Desktop Professional.
ProClarity Desktop Professional - Standard "Setup.exe" install on client. Can open Desktop Professional and access a cube directly withouth having a PAS server involved.
If you are using ProClarity Standard, then you do not connect directly to an AS server. The connection to the AS server is made by the PAS server. When you execute an MDX statement, the PAS server sends the MDX to the server, renders the resulting view and then passes back DHTML to the client. In this case, as was correctly pointed out, if the PAS server and AS server are on different servers then you will have to use either Basic Authentication or implement Kerberos to allow the PAS server to delegate user credentials to the AS server.
If you are using either Web Professional or Desktop Professional, then you are connecting from the client directly to the AS server and there should be no need to do anything special.
HTH,
Steve
Tuesday, March 20, 2012
processing speed, optimizations for AMD Opteron
Does anyone know if Analysis Services has binaries optimized for AMD Opteron? The reason I ask is that I am seeing a dramatic performance difference between the 2 systems:
System: Dual Xeon Irwingdale 3.4 GHz, Chipset E7525, 4GB Ram
OS: Windows XP Pro SP2
Fact Rows: 20,000,000
Aggregations: 1300
Processing Time: 3 Hrs
System: Dual AMD Opteron 246 (2.0 GHz), AMD Chipset 8000 (MB Tyan S2885). 4 GB RAM
OS: Windows 2003 Enterprise (SP1)
Fact Rows: 20,000,000 (same data set as 1st case)
Aggregations: 1300
Processing Time: 6-7 Hrs
Both test environments have the:
Same RAM speed
Same model HDDs
Is this difference due to any lack of AMD-specific optimizations in SSAS binaries? or some other reason?
Also is there any way to reduce the thread priority on SSAS binary during optimization? It seems to almost completely hose the machine (windows 2003 ent.) during processing. When attempted to change processing priority through task manager I got access denier error (logged in as admin)Did you test under the same OS and 100% equial another options?
Such difference as you have acounted seems to be too screwy.|||
Vladimir Chtepa wrote:
Did you test under the same OS and 100% equial another options? Such difference as you have acounted seems to be too screwy.
The operating systems are different - Windows XP SP2 vs. Windows 2003 SP1.
SSAS options are all same.
Also when its processing on Windows 2003 SP1/AMD Opteron test environment it is much harder to use any other applications (open windows, task manager, etc) than on the Windows XP. The AMD/Windows2003 gets very hosed/hung up when processing at 100% CPU.
On other hand the IntelXeon/Win XP case it still responsive even when processing faster and at 100% CPU for hours.
Processing responsibilities - RS services vs. repository
Hi - Can someone please explain the split of processing that occurs (i.e.
what processing occurs where) in terms of between the Reporting Services
server itself vs. on the repository server (if different)? Specifically, we
see that there are many scheduled jobs in the SQL Agent on the repository
server, which potentially look related to scheduled/subscription jobs in RS,
but not sure. We'd like to understand this split of work from a workload
planning point of view.
thanksSomeone at MSFT will add more detail to this or correct me, but essentially
what I think happens is that when you schedule a job like a subscription, SQL
Server Agent adds an event to a table at the appointed times. [Look at the
job step details and you will see that they are all running a stored
procedure called AddEvent]. The table is constantly being polled by the
Report Server Windows Service. When there is an event that has been added,
Report Server then sees it and gets the job done, I think by making the
appropriate calls to the Report Server web service. The Report Server web
service and the Report Server Windows service are two separate things.
The Report Server obviously has the responsibility of performing the job,
and this might involve sending a query to the catalog to get the relevant
information. So really SQL Server Agent just adds an event to a table so that
the Windows service sees it.
Take a look also at the performance objects RS Web Service and RS Windows
Service in System Monitor or Performance Monitor.
Cheers
Charles Kangai, MCT, MCDBA
"ISGADMIN" wrote:
> Hi - Can someone please explain the split of processing that occurs (i.e.
> what processing occurs where) in terms of between the Reporting Services
> server itself vs. on the repository server (if different)? Specifically, we
> see that there are many scheduled jobs in the SQL Agent on the repository
> server, which potentially look related to scheduled/subscription jobs in RS,
> but not sure. We'd like to understand this split of work from a workload
> planning point of view.
> thanks|||Hi Charles thanks for the info. Do you know if the repository is also used
during other non-subscription operations like normal report rendering?
Clearly there must be an initial lookup in order to get report params,
security, etc. and anything else stored in the repository, but from a
capacity planning point of view I am interested to know how to plan for the
server holding the repository as a function of the load on my RS server
itself.
regards
"Charles Kangai" wrote:
> Someone at MSFT will add more detail to this or correct me, but essentially
> what I think happens is that when you schedule a job like a subscription, SQL
> Server Agent adds an event to a table at the appointed times. [Look at the
> job step details and you will see that they are all running a stored
> procedure called AddEvent]. The table is constantly being polled by the
> Report Server Windows Service. When there is an event that has been added,
> Report Server then sees it and gets the job done, I think by making the
> appropriate calls to the Report Server web service. The Report Server web
> service and the Report Server Windows service are two separate things.
> The Report Server obviously has the responsibility of performing the job,
> and this might involve sending a query to the catalog to get the relevant
> information. So really SQL Server Agent just adds an event to a table so that
> the Windows service sees it.
> Take a look also at the performance objects RS Web Service and RS Windows
> Service in System Monitor or Performance Monitor.
> Cheers
> Charles Kangai, MCT, MCDBA
> "ISGADMIN" wrote:
> > Hi - Can someone please explain the split of processing that occurs (i.e.
> > what processing occurs where) in terms of between the Reporting Services
> > server itself vs. on the repository server (if different)? Specifically, we
> > see that there are many scheduled jobs in the SQL Agent on the repository
> > server, which potentially look related to scheduled/subscription jobs in RS,
> > but not sure. We'd like to understand this split of work from a workload
> > planning point of view.
> >
> > thanks|||The ReportServer catalog is certainly queried during normal operations like
rendering, because that is where the report definitions are stored. Once you
deploy your reports or support files, they are stored in the Report Server
catalog. The Report Server catalog is Report Server database. Open your
ReportServer database using Enterprise Manager and take a look at some of the
tables. You will see your reports in the Catalog table. Whenever reports run
the reports also get temporarily cached in unrendered format in the databases
(there is another database used called ReportServerTempDB).
Check this information out in Books Online. It is all there.
cheers
Charles Kangai, MCT, MCDBA
"ISGADMIN" wrote:
> Hi Charles thanks for the info. Do you know if the repository is also used
> during other non-subscription operations like normal report rendering?
> Clearly there must be an initial lookup in order to get report params,
> security, etc. and anything else stored in the repository, but from a
> capacity planning point of view I am interested to know how to plan for the
> server holding the repository as a function of the load on my RS server
> itself.
> regards
> "Charles Kangai" wrote:
> > Someone at MSFT will add more detail to this or correct me, but essentially
> > what I think happens is that when you schedule a job like a subscription, SQL
> > Server Agent adds an event to a table at the appointed times. [Look at the
> > job step details and you will see that they are all running a stored
> > procedure called AddEvent]. The table is constantly being polled by the
> > Report Server Windows Service. When there is an event that has been added,
> > Report Server then sees it and gets the job done, I think by making the
> > appropriate calls to the Report Server web service. The Report Server web
> > service and the Report Server Windows service are two separate things.
> >
> > The Report Server obviously has the responsibility of performing the job,
> > and this might involve sending a query to the catalog to get the relevant
> > information. So really SQL Server Agent just adds an event to a table so that
> > the Windows service sees it.
> >
> > Take a look also at the performance objects RS Web Service and RS Windows
> > Service in System Monitor or Performance Monitor.
> >
> > Cheers
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "ISGADMIN" wrote:
> >
> > > Hi - Can someone please explain the split of processing that occurs (i.e.
> > > what processing occurs where) in terms of between the Reporting Services
> > > server itself vs. on the repository server (if different)? Specifically, we
> > > see that there are many scheduled jobs in the SQL Agent on the repository
> > > server, which potentially look related to scheduled/subscription jobs in RS,
> > > but not sure. We'd like to understand this split of work from a workload
> > > planning point of view.
> > >
> > > thanks
what processing occurs where) in terms of between the Reporting Services
server itself vs. on the repository server (if different)? Specifically, we
see that there are many scheduled jobs in the SQL Agent on the repository
server, which potentially look related to scheduled/subscription jobs in RS,
but not sure. We'd like to understand this split of work from a workload
planning point of view.
thanksSomeone at MSFT will add more detail to this or correct me, but essentially
what I think happens is that when you schedule a job like a subscription, SQL
Server Agent adds an event to a table at the appointed times. [Look at the
job step details and you will see that they are all running a stored
procedure called AddEvent]. The table is constantly being polled by the
Report Server Windows Service. When there is an event that has been added,
Report Server then sees it and gets the job done, I think by making the
appropriate calls to the Report Server web service. The Report Server web
service and the Report Server Windows service are two separate things.
The Report Server obviously has the responsibility of performing the job,
and this might involve sending a query to the catalog to get the relevant
information. So really SQL Server Agent just adds an event to a table so that
the Windows service sees it.
Take a look also at the performance objects RS Web Service and RS Windows
Service in System Monitor or Performance Monitor.
Cheers
Charles Kangai, MCT, MCDBA
"ISGADMIN" wrote:
> Hi - Can someone please explain the split of processing that occurs (i.e.
> what processing occurs where) in terms of between the Reporting Services
> server itself vs. on the repository server (if different)? Specifically, we
> see that there are many scheduled jobs in the SQL Agent on the repository
> server, which potentially look related to scheduled/subscription jobs in RS,
> but not sure. We'd like to understand this split of work from a workload
> planning point of view.
> thanks|||Hi Charles thanks for the info. Do you know if the repository is also used
during other non-subscription operations like normal report rendering?
Clearly there must be an initial lookup in order to get report params,
security, etc. and anything else stored in the repository, but from a
capacity planning point of view I am interested to know how to plan for the
server holding the repository as a function of the load on my RS server
itself.
regards
"Charles Kangai" wrote:
> Someone at MSFT will add more detail to this or correct me, but essentially
> what I think happens is that when you schedule a job like a subscription, SQL
> Server Agent adds an event to a table at the appointed times. [Look at the
> job step details and you will see that they are all running a stored
> procedure called AddEvent]. The table is constantly being polled by the
> Report Server Windows Service. When there is an event that has been added,
> Report Server then sees it and gets the job done, I think by making the
> appropriate calls to the Report Server web service. The Report Server web
> service and the Report Server Windows service are two separate things.
> The Report Server obviously has the responsibility of performing the job,
> and this might involve sending a query to the catalog to get the relevant
> information. So really SQL Server Agent just adds an event to a table so that
> the Windows service sees it.
> Take a look also at the performance objects RS Web Service and RS Windows
> Service in System Monitor or Performance Monitor.
> Cheers
> Charles Kangai, MCT, MCDBA
> "ISGADMIN" wrote:
> > Hi - Can someone please explain the split of processing that occurs (i.e.
> > what processing occurs where) in terms of between the Reporting Services
> > server itself vs. on the repository server (if different)? Specifically, we
> > see that there are many scheduled jobs in the SQL Agent on the repository
> > server, which potentially look related to scheduled/subscription jobs in RS,
> > but not sure. We'd like to understand this split of work from a workload
> > planning point of view.
> >
> > thanks|||The ReportServer catalog is certainly queried during normal operations like
rendering, because that is where the report definitions are stored. Once you
deploy your reports or support files, they are stored in the Report Server
catalog. The Report Server catalog is Report Server database. Open your
ReportServer database using Enterprise Manager and take a look at some of the
tables. You will see your reports in the Catalog table. Whenever reports run
the reports also get temporarily cached in unrendered format in the databases
(there is another database used called ReportServerTempDB).
Check this information out in Books Online. It is all there.
cheers
Charles Kangai, MCT, MCDBA
"ISGADMIN" wrote:
> Hi Charles thanks for the info. Do you know if the repository is also used
> during other non-subscription operations like normal report rendering?
> Clearly there must be an initial lookup in order to get report params,
> security, etc. and anything else stored in the repository, but from a
> capacity planning point of view I am interested to know how to plan for the
> server holding the repository as a function of the load on my RS server
> itself.
> regards
> "Charles Kangai" wrote:
> > Someone at MSFT will add more detail to this or correct me, but essentially
> > what I think happens is that when you schedule a job like a subscription, SQL
> > Server Agent adds an event to a table at the appointed times. [Look at the
> > job step details and you will see that they are all running a stored
> > procedure called AddEvent]. The table is constantly being polled by the
> > Report Server Windows Service. When there is an event that has been added,
> > Report Server then sees it and gets the job done, I think by making the
> > appropriate calls to the Report Server web service. The Report Server web
> > service and the Report Server Windows service are two separate things.
> >
> > The Report Server obviously has the responsibility of performing the job,
> > and this might involve sending a query to the catalog to get the relevant
> > information. So really SQL Server Agent just adds an event to a table so that
> > the Windows service sees it.
> >
> > Take a look also at the performance objects RS Web Service and RS Windows
> > Service in System Monitor or Performance Monitor.
> >
> > Cheers
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "ISGADMIN" wrote:
> >
> > > Hi - Can someone please explain the split of processing that occurs (i.e.
> > > what processing occurs where) in terms of between the Reporting Services
> > > server itself vs. on the repository server (if different)? Specifically, we
> > > see that there are many scheduled jobs in the SQL Agent on the repository
> > > server, which potentially look related to scheduled/subscription jobs in RS,
> > > but not sure. We'd like to understand this split of work from a workload
> > > planning point of view.
> > >
> > > thanks
Processing of AS2005 cube from Integration Services package: Operation completed with 882 proble
Hi!
I did not now if I should post it in the Integration Services forum, but I believe this post is more AS related. Anyway, I am processing my cubes in SSIS after some loading of data. I use the SSIS log provider for SQL Server to log errors, and I get the following error message in the message column of a row in sysdtslog90:
"Server: Operation completed with 882 problems logged."
I wonder, where can I find this log? Is there some default location in AS or do I have to enable another log event than OnError or OnWarning in SSIS?
Thanks!
I'm guessing I'm looking for the Dimension key error log path when it is set for (default).
I found something here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1284202&SiteID=1
Seems like you have to set the location in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config\msmdsrv.ini. Now I get a key error logfile, but it is empty =/. I've restarted the AS service and set the ErrorLog elements in the ini to:
<ErrorLog>
<ErrorLogFileName>OLAPErrorLog.log</ErrorLogFileName>
<ErrorLogFileSize>4</ErrorLogFileSize>
<KeyErrorAction>0</KeyErrorAction>
<KeyErrorLogFile>KeyErrorLogFile.log</KeyErrorLogFile>
<KeyErrorLimit>0</KeyErrorLimit>
<KeyErrorLimitAction>0</KeyErrorLimitAction>
<LogErrorTypes>
<KeyNotFound>1</KeyNotFound>
<KeyDuplicate>0</KeyDuplicate>
<NullKeyConvertedToUnknown>0</NullKeyConvertedToUnknown>
<NullKeyNotAllowed>1</NullKeyNotAllowed>
</LogErrorTypes>
<IgnoreDataTruncation>0</IgnoreDataTruncation>
</ErrorLog>
I've also tested the following without success:
<ErrorLog>
<ErrorLogFileName>OLAPErrorLog.log</ErrorLogFileName>
<ErrorLogFileSize>4000000</ErrorLogFileSize>
<KeyErrorAction>1</KeyErrorAction>
<KeyErrorLogFile>KeyErrorLogFile.log</KeyErrorLogFile>
<KeyErrorLimit>1</KeyErrorLimit>
<KeyErrorLimitAction>1</KeyErrorLimitAction>
<LogErrorTypes>
<KeyNotFound>1</KeyNotFound>
<KeyDuplicate>1</KeyDuplicate>
<NullKeyConvertedToUnknown>1</NullKeyConvertedToUnknown>
<NullKeyNotAllowed>1</NullKeyNotAllowed>
</LogErrorTypes>
<IgnoreDataTruncation>0</IgnoreDataTruncation>
</ErrorLog>
More info here, but it does not get you that much wiser: http://technet.microsoft.com/en-us/library/ms174827.aspx
Seems like you do have to set the ErrorLog properties manually for each cube (Process > Change Settings > Use custom error configuration).
Processing Mining Models & Structures via SSIS
Still new to DM and SSIS...anyand all help is greatly appreciated!
In SSIS they say that you can use the Analysis Services Processing Task to process a mining model/mining structure, however, I do not see where you can give it a relational table to work off of. I know that I can use a data flow to do this but I wanted to go a different route if I could to process my models as I don't really necessarily need the data flow as what I am tring to do is pretty simple.
That brings me to a more general question, what is the best method for training your models using SSIS? I am building a new model everytime the package runs using some variables and the DDL task, running a query on it, and destroying it at the end of the package but I am having logistical problems training it outside of the data flow. I tried using the DM Query task but it requires that you output a result set and I am not sure if I can use it to create and process models.
I would think that they would just give you a DMX task similar to the SQL task but that does not seem to be the case. Also, when I browse the AS objects via the processing task I can only see the mining structures and not the mining models.
Am I just missing something here?
Cheers,
Dan Meyers
If you just want to process the mining models/structure, you should use the Analysis Services processing task. If you wnat more flexibility, you can use the Analysis Services Execute DDL task (you can do pretty much anything there). There is a feature called "out of line bindings" that you can specify if you want to proecess against different data than the model was bound to in the DSV - I'm not sure of the documentation level on this feature though.
You are right that you can't use the DM Query task for the reason you stated - you can use the DDL task as in this tip http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1443.aspx to process using DMX, or execute any other non-rowset returning DMX statement.
On the point of what happens during the data flow execution, the model/structure is only created at design time. The processing happens at run time. This means that if you wanted to run this package against another server, you would first have to create the model on that server. The easiest method may be to use SSMS to script the structure to create and then use the DDL task again
HTH
-Jamie
|||Interesting...I did not realize that you could use the DDL task to execute DMX statments. Makes perfect sense since it all gets broken down to XMLA anyway. This is exactly the answer I was looking for. You are like the Yoda of SQL DM. Once again, thanks for the help.
-Dan Meyers
|||Jamie,
I have another more question on this...Do I have to build a new DSV for my mining model or can I just use the same one that I am using for my OLAP cubes?
|||You can use the same DSV - the DSV is simply a collection of tables/named queries that don't necessarily have to be relatedMonday, March 12, 2012
Processing is very slow and rendering report in PDF is very slow. Need suggestions and a s
Hi,
I am trying to re-engineer a report that was originally developed in
Crystal 7 into SQL Server 2000 Reporting Services. The reason for this
is that we are moving to a new infrastructure that is running Windows
2003 Server. Crystal 7 is unsupported and it won't even install.
The report has one parameter: a string variable that can be up to 15
characters long.
The original report in Crystal 7 had two subreports each with a
grouping level linked to a master report with three grouping levels.
The first cut of this report in SQL Server 2000 Reporting Services is
producing the correct amounts. But processing and rendering this
report in PDF (this would be the preferred method) is taking forever.
I have no sub reports in this first design. I embedded sub-tables (two
with one group level each) with another table (with three grouping
levels). There are embedded lists inside these tables. I merged all
the rows together and embedded a list inside to position elements in
the report. Even rendering a row of data is taking too long.
Could I send this report (RDL file) to someone at Microsoft to look at
the design and give me suggestions on what to try next?
I am thinking on removing the groups. I just don't know how I would
link the master dataset with another dataset that is grouping the data
based on the parameter sent.
I have a real short time frame to get this to work and I am not finding
a lot of documentation on performance improvements. Once I correspond
with a Microsoft expert, I could discuss the design, data amounts, and
execution/rendering time frames.Do you have SP1 installed. There were significant improvements in PDF
performance with SP1.
To check version go to http://yourserver/Reportserver
It should be version 8.00.878.00.
If not, that is the first thing I would do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mossman" <tmosson1@.sbcglobal.net> wrote in message
news:1107912663.898526.219740@.g14g2000cwa.googlegroups.com...
> Hi,
> I am trying to re-engineer a report that was originally developed in
> Crystal 7 into SQL Server 2000 Reporting Services. The reason for this
> is that we are moving to a new infrastructure that is running Windows
> 2003 Server. Crystal 7 is unsupported and it won't even install.
> The report has one parameter: a string variable that can be up to 15
> characters long.
> The original report in Crystal 7 had two subreports each with a
> grouping level linked to a master report with three grouping levels.
> The first cut of this report in SQL Server 2000 Reporting Services is
> producing the correct amounts. But processing and rendering this
> report in PDF (this would be the preferred method) is taking forever.
> I have no sub reports in this first design. I embedded sub-tables (two
> with one group level each) with another table (with three grouping
> levels). There are embedded lists inside these tables. I merged all
> the rows together and embedded a list inside to position elements in
> the report. Even rendering a row of data is taking too long.
> Could I send this report (RDL file) to someone at Microsoft to look at
> the design and give me suggestions on what to try next?
> I am thinking on removing the groups. I just don't know how I would
> link the master dataset with another dataset that is grouping the data
> based on the parameter sent.
> I have a real short time frame to get this to work and I am not finding
> a lot of documentation on performance improvements. Once I correspond
> with a Microsoft expert, I could discuss the design, data amounts, and
> execution/rendering time frames.
>|||Yes, we have SP1 installed. Maximum amount of data brought back by a
parameter value is 20698. I run the query in query analyzer based on
the parameter value and it takes up to 24 secs. It seems I am having
problems when the record count is around 1000 or greater. Need to keep
the structure of the report the same as it was in Crystal but I need to
speed up the processing. I could look into re-engineering the query as
well. We have the RSExecutionLog process setup. Looking at the data
it seems a lot time is spent processing and rendering. By the way, the
TimeDataRetrieval, TimeProcessing, and TimeRendering attributes, is the
numeric data in milliseconds?|||Yes, we have SP1 installed. Maximum amount of data brought back by a
parameter value is 20698. I run the query in query analyzer based on
the parameter value and it takes up to 24 secs. It seems I am having
problems when the record count is around 1000 or greater. Need to keep
the structure of the report the same as it was in Crystal but I need to
speed up the processing. I could look into re-engineering the query as
well. We have the RSExecutionLog process setup. Looking at the data
it seems a lot time is spent processing and rendering. By the way, the
TimeDataRetrieval, TimeProcessing, and TimeRendering attributes in the
ExecutionLogs table in the RSExecutionLog DB, is the numeric data in
milliseconds?|||This is a 500 plus page report if I understand correctly. RS does all this
in memory and when you have grouping it definitely takes longer. As an
experiment I would try removing all groups (don't worry about what it looks
like, just see if this speeds it up substantially). If there is any work you
could put into a stored procedure I would do that as well. But, the real
issue could just be the shear amount of processing you are requiring to
render this. My philosophy is that reports are for humans to read. No human
is going to sit down and read 500 pages. RS is great if you want to create
reports that someone is going to use and look at. It is not good for large
number of pages (I've seen someone with a 1,000 page report as a
requirement). Where it shines is having on-line reports. I provide summary
reports and then the user does drill throughs to get to more detail about
the information they need. If you can I would look at the requirements and
see if it could be designed a different way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mossman" <tmosson1@.sbcglobal.net> wrote in message
news:1107977412.708510.39290@.g14g2000cwa.googlegroups.com...
> Yes, we have SP1 installed. Maximum amount of data brought back by a
> parameter value is 20698. I run the query in query analyzer based on
> the parameter value and it takes up to 24 secs. It seems I am having
> problems when the record count is around 1000 or greater. Need to keep
> the structure of the report the same as it was in Crystal but I need to
> speed up the processing. I could look into re-engineering the query as
> well. We have the RSExecutionLog process setup. Looking at the data
> it seems a lot time is spent processing and rendering. By the way, the
> TimeDataRetrieval, TimeProcessing, and TimeRendering attributes in the
> ExecutionLogs table in the RSExecutionLog DB, is the numeric data in
> milliseconds?
>
I am trying to re-engineer a report that was originally developed in
Crystal 7 into SQL Server 2000 Reporting Services. The reason for this
is that we are moving to a new infrastructure that is running Windows
2003 Server. Crystal 7 is unsupported and it won't even install.
The report has one parameter: a string variable that can be up to 15
characters long.
The original report in Crystal 7 had two subreports each with a
grouping level linked to a master report with three grouping levels.
The first cut of this report in SQL Server 2000 Reporting Services is
producing the correct amounts. But processing and rendering this
report in PDF (this would be the preferred method) is taking forever.
I have no sub reports in this first design. I embedded sub-tables (two
with one group level each) with another table (with three grouping
levels). There are embedded lists inside these tables. I merged all
the rows together and embedded a list inside to position elements in
the report. Even rendering a row of data is taking too long.
Could I send this report (RDL file) to someone at Microsoft to look at
the design and give me suggestions on what to try next?
I am thinking on removing the groups. I just don't know how I would
link the master dataset with another dataset that is grouping the data
based on the parameter sent.
I have a real short time frame to get this to work and I am not finding
a lot of documentation on performance improvements. Once I correspond
with a Microsoft expert, I could discuss the design, data amounts, and
execution/rendering time frames.Do you have SP1 installed. There were significant improvements in PDF
performance with SP1.
To check version go to http://yourserver/Reportserver
It should be version 8.00.878.00.
If not, that is the first thing I would do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mossman" <tmosson1@.sbcglobal.net> wrote in message
news:1107912663.898526.219740@.g14g2000cwa.googlegroups.com...
> Hi,
> I am trying to re-engineer a report that was originally developed in
> Crystal 7 into SQL Server 2000 Reporting Services. The reason for this
> is that we are moving to a new infrastructure that is running Windows
> 2003 Server. Crystal 7 is unsupported and it won't even install.
> The report has one parameter: a string variable that can be up to 15
> characters long.
> The original report in Crystal 7 had two subreports each with a
> grouping level linked to a master report with three grouping levels.
> The first cut of this report in SQL Server 2000 Reporting Services is
> producing the correct amounts. But processing and rendering this
> report in PDF (this would be the preferred method) is taking forever.
> I have no sub reports in this first design. I embedded sub-tables (two
> with one group level each) with another table (with three grouping
> levels). There are embedded lists inside these tables. I merged all
> the rows together and embedded a list inside to position elements in
> the report. Even rendering a row of data is taking too long.
> Could I send this report (RDL file) to someone at Microsoft to look at
> the design and give me suggestions on what to try next?
> I am thinking on removing the groups. I just don't know how I would
> link the master dataset with another dataset that is grouping the data
> based on the parameter sent.
> I have a real short time frame to get this to work and I am not finding
> a lot of documentation on performance improvements. Once I correspond
> with a Microsoft expert, I could discuss the design, data amounts, and
> execution/rendering time frames.
>|||Yes, we have SP1 installed. Maximum amount of data brought back by a
parameter value is 20698. I run the query in query analyzer based on
the parameter value and it takes up to 24 secs. It seems I am having
problems when the record count is around 1000 or greater. Need to keep
the structure of the report the same as it was in Crystal but I need to
speed up the processing. I could look into re-engineering the query as
well. We have the RSExecutionLog process setup. Looking at the data
it seems a lot time is spent processing and rendering. By the way, the
TimeDataRetrieval, TimeProcessing, and TimeRendering attributes, is the
numeric data in milliseconds?|||Yes, we have SP1 installed. Maximum amount of data brought back by a
parameter value is 20698. I run the query in query analyzer based on
the parameter value and it takes up to 24 secs. It seems I am having
problems when the record count is around 1000 or greater. Need to keep
the structure of the report the same as it was in Crystal but I need to
speed up the processing. I could look into re-engineering the query as
well. We have the RSExecutionLog process setup. Looking at the data
it seems a lot time is spent processing and rendering. By the way, the
TimeDataRetrieval, TimeProcessing, and TimeRendering attributes in the
ExecutionLogs table in the RSExecutionLog DB, is the numeric data in
milliseconds?|||This is a 500 plus page report if I understand correctly. RS does all this
in memory and when you have grouping it definitely takes longer. As an
experiment I would try removing all groups (don't worry about what it looks
like, just see if this speeds it up substantially). If there is any work you
could put into a stored procedure I would do that as well. But, the real
issue could just be the shear amount of processing you are requiring to
render this. My philosophy is that reports are for humans to read. No human
is going to sit down and read 500 pages. RS is great if you want to create
reports that someone is going to use and look at. It is not good for large
number of pages (I've seen someone with a 1,000 page report as a
requirement). Where it shines is having on-line reports. I provide summary
reports and then the user does drill throughs to get to more detail about
the information they need. If you can I would look at the requirements and
see if it could be designed a different way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mossman" <tmosson1@.sbcglobal.net> wrote in message
news:1107977412.708510.39290@.g14g2000cwa.googlegroups.com...
> Yes, we have SP1 installed. Maximum amount of data brought back by a
> parameter value is 20698. I run the query in query analyzer based on
> the parameter value and it takes up to 24 secs. It seems I am having
> problems when the record count is around 1000 or greater. Need to keep
> the structure of the report the same as it was in Crystal but I need to
> speed up the processing. I could look into re-engineering the query as
> well. We have the RSExecutionLog process setup. Looking at the data
> it seems a lot time is spent processing and rendering. By the way, the
> TimeDataRetrieval, TimeProcessing, and TimeRendering attributes in the
> ExecutionLogs table in the RSExecutionLog DB, is the numeric data in
> milliseconds?
>
processing has been canceled by the user ?
hi all,
sometimes i am seeing a error , when i am trying to gegerate a report
please help .........
---
Reporting Services Error
----
Report processing has been canceled by the user. (rsProcessingAborted) Get
Online HelpOn Jan 18, 8:53 am, "jelzi" <je...@.discussions.microsoft.com> wrote:
> hi all,
> sometimes i am seeing a error , when i am trying to gegerate a report
> please help .........
> ---
> Reporting Services Error
> ----
> Report processing has been canceled by the user. (rsProcessingAborted) Get
> Online Help
You will most likely want to increase your timeout value in the site
settings. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||hi Enrique,
where is this setting ?
regards
jelzi
>> hi all,
>> sometimes i am seeing a error , when i am trying to gegerate a report
>> please help .........
>> ---
>> Reporting Services Error
>> ----
>> Report processing has been canceled by the user. (rsProcessingAborted)
>> Get
>> Online Help
>
> You will most likely want to increase your timeout value in the site
> settings. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
sometimes i am seeing a error , when i am trying to gegerate a report
please help .........
---
Reporting Services Error
----
Report processing has been canceled by the user. (rsProcessingAborted) Get
Online HelpOn Jan 18, 8:53 am, "jelzi" <je...@.discussions.microsoft.com> wrote:
> hi all,
> sometimes i am seeing a error , when i am trying to gegerate a report
> please help .........
> ---
> Reporting Services Error
> ----
> Report processing has been canceled by the user. (rsProcessingAborted) Get
> Online Help
You will most likely want to increase your timeout value in the site
settings. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||hi Enrique,
where is this setting ?
regards
jelzi
>> hi all,
>> sometimes i am seeing a error , when i am trying to gegerate a report
>> please help .........
>> ---
>> Reporting Services Error
>> ----
>> Report processing has been canceled by the user. (rsProcessingAborted)
>> Get
>> Online Help
>
> You will most likely want to increase your timeout value in the site
> settings. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Processing cubes on a different server, using SSIS package run by a SQL Agent job from another s
Hi,
I am faced with this issue in a production environment. I have to implement an architecture where the Analysis Services database is in a server different from the server on which the SQL Serever database it accesses for data is.
I have changed the connection string for the data source in the Analysis Services database to point to the other server's SQL Server database. Log on to this server has been set to use SQL Server Authentication.
Then I created an SSIS package on the server containing SQL Server database, to process a dimension in the other server's Analysis Services database. The Analysis Services connection manager in this package was set to log on to the Analysis Services database on the other server using 'Specific User name and Password'. This user is a part of the administrator group on the server containing Analysis Services database. The package executed fine when executed from the Business Intelligence Studio.
The problem came when I tried to execute this package through a SQL agent job. The job is created on the server containing the SQL Server database. The step in the job meant to execute the package uses 'SQL Agent Service Account' for the 'Run as' option. The package was deployed as 'File System'.
I missed out posting the error message I am getting. It is as follows:
Code: 0x00000000 Description: A connection cannot be made. Ensure that the server is running.
Hope this helps to give a better understanding of the problem.
Thanks.
|||Hi,
The problem was resolved by changing the LOG ON for the SSIS service to that of an user who is administrator on both the machines.
|||Did you have to create a Credential and Proxy? I had to create one and set the Run As parameter for the step in Agent to the Proxy name. The job has to write a file to a network directory and from what I read it seems that the only way for an SSIS job to access anything outside SQL Server was by using a proxy. I am not sure if the same applied in your situation.
|||Hmm.... I was helped by the fact that the OS was installed with a network administrator id. So no new credentials or proxy was required. The run as parameter for my job's step remained as "SQL Agent Service Account" and changed the Log On for SSIS service to use network administrator account. Hope this helps.
I would like to know how you created a proxy and made the Run As parameter to point to it.
Regards,
Emil
Subscribe to:
Posts (Atom)