Hello,
I'm using Windows Server 2003 Standard Edition which has multiple instances
of SQL Server 2005 standard edition. Am running a few tests that require the
switching on/off of the physical & logical disk counters.
Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
Either both (Logical & Physical) are enabled or both are disabled.
How can I turn them on/off individually?
Cheers!
Sqlcatz
The implementation of this changed on Windows 2003. Both
logical and physical are automatically enabled "on demand"
under Win 2003.
-Sue
On Mon, 9 Oct 2006 03:51:02 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>I'm using Windows Server 2003 Standard Edition which has multiple instances
>of SQL Server 2005 standard edition. Am running a few tests that require the
>switching on/off of the physical & logical disk counters.
>Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
>Either both (Logical & Physical) are enabled or both are disabled.
>How can I turn them on/off individually?
>Cheers!
>Sqlcatz
|||Hello Sue,
Thank you for the reply.
Yes. They are automatically enabled - I came across that from an article.
But I'm not able to find anything that will allow me to disable them
(individually).
I'm executing certain tests for an application one of which requires that
these counters be disabled.
Is there any specific reason for Windows Server 2003 Standard Edition to
prevent the enabling/disabling of these counters? Can you point me to some
literature regarding this. I can accept the fact that this kind of behaviour
is not allowed - but need to know why - so that I provide a technical/logical
reason.
Cheers!
sqlcatz
|||The are enabled when an application calls them - it's
automatic and built into the OS.
Previously, there were problems when you would have a
production performance issue and needed to monitor disks. If
the performance counters weren't enabled, you had to run
diskperf and reboot - not good for a production server.
You can run diskperf /help from the command line and read
the comments. That's one area of "documentation" on it - for
whatever that's worth. But the output is along the lines of:
NOTE: Disk performance counters are permanently enabled on
systems beyond Windows 2000.
-Sue
On Tue, 10 Oct 2006 22:13:01 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello Sue,
>Thank you for the reply.
>Yes. They are automatically enabled - I came across that from an article.
>But I'm not able to find anything that will allow me to disable them
>(individually).
>I'm executing certain tests for an application one of which requires that
>these counters be disabled.
>Is there any specific reason for Windows Server 2003 Standard Edition to
>prevent the enabling/disabling of these counters? Can you point me to some
>literature regarding this. I can accept the fact that this kind of behaviour
>is not allowed - but need to know why - so that I provide a technical/logical
>reason.
>Cheers!
>sqlcatz
|||Thank you Sue!
sqlcatz
2012年3月29日星期四
Diskperf on Windows Server 2003 Standard Edition.
Hello,
I'm using Windows Server 2003 Standard Edition which has multiple instances
of SQL Server 2005 standard edition. Am running a few tests that require the
switching on/off of the physical & logical disk counters.
Diskperf on Windows Server 2003 Standard Edition does not allow me to do thi
s.
Either both (Logical & Physical) are enabled or both are disabled.
How can I turn them on/off individually?
Cheers!
SqlcatzThe implementation of this changed on Windows 2003. Both
logical and physical are automatically enabled "on demand"
under Win 2003.
-Sue
On Mon, 9 Oct 2006 03:51:02 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>I'm using Windows Server 2003 Standard Edition which has multiple instances
>of SQL Server 2005 standard edition. Am running a few tests that require th
e
>switching on/off of the physical & logical disk counters.
>Diskperf on Windows Server 2003 Standard Edition does not allow me to do th
is.
>Either both (Logical & Physical) are enabled or both are disabled.
>How can I turn them on/off individually?
>Cheers!
>Sqlcatz|||Hello Sue,
Thank you for the reply.
Yes. They are automatically enabled - I came across that from an article.
But I'm not able to find anything that will allow me to disable them
(individually).
I'm executing certain tests for an application one of which requires that
these counters be disabled.
Is there any specific reason for Windows Server 2003 Standard Edition to
prevent the enabling/disabling of these counters? Can you point me to some
literature regarding this. I can accept the fact that this kind of behaviour
is not allowed - but need to know why - so that I provide a technical/logica
l
reason.
Cheers!
sqlcatz|||The are enabled when an application calls them - it's
automatic and built into the OS.
Previously, there were problems when you would have a
production performance issue and needed to monitor disks. If
the performance counters weren't enabled, you had to run
diskperf and reboot - not good for a production server.
You can run diskperf /help from the command line and read
the comments. That's one area of "documentation" on it - for
whatever that's worth. But the output is along the lines of:
NOTE: Disk performance counters are permanently enabled on
systems beyond Windows 2000.
-Sue
On Tue, 10 Oct 2006 22:13:01 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello Sue,
>Thank you for the reply.
>Yes. They are automatically enabled - I came across that from an article.
>But I'm not able to find anything that will allow me to disable them
>(individually).
>I'm executing certain tests for an application one of which requires that
>these counters be disabled.
>Is there any specific reason for Windows Server 2003 Standard Edition to
>prevent the enabling/disabling of these counters? Can you point me to some
>literature regarding this. I can accept the fact that this kind of behaviou
r
>is not allowed - but need to know why - so that I provide a technical/logic
al
>reason.
>Cheers!
>sqlcatz|||Thank you Sue!
sqlcatz
I'm using Windows Server 2003 Standard Edition which has multiple instances
of SQL Server 2005 standard edition. Am running a few tests that require the
switching on/off of the physical & logical disk counters.
Diskperf on Windows Server 2003 Standard Edition does not allow me to do thi
s.
Either both (Logical & Physical) are enabled or both are disabled.
How can I turn them on/off individually?
Cheers!
SqlcatzThe implementation of this changed on Windows 2003. Both
logical and physical are automatically enabled "on demand"
under Win 2003.
-Sue
On Mon, 9 Oct 2006 03:51:02 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>I'm using Windows Server 2003 Standard Edition which has multiple instances
>of SQL Server 2005 standard edition. Am running a few tests that require th
e
>switching on/off of the physical & logical disk counters.
>Diskperf on Windows Server 2003 Standard Edition does not allow me to do th
is.
>Either both (Logical & Physical) are enabled or both are disabled.
>How can I turn them on/off individually?
>Cheers!
>Sqlcatz|||Hello Sue,
Thank you for the reply.
Yes. They are automatically enabled - I came across that from an article.
But I'm not able to find anything that will allow me to disable them
(individually).
I'm executing certain tests for an application one of which requires that
these counters be disabled.
Is there any specific reason for Windows Server 2003 Standard Edition to
prevent the enabling/disabling of these counters? Can you point me to some
literature regarding this. I can accept the fact that this kind of behaviour
is not allowed - but need to know why - so that I provide a technical/logica
l
reason.
Cheers!
sqlcatz|||The are enabled when an application calls them - it's
automatic and built into the OS.
Previously, there were problems when you would have a
production performance issue and needed to monitor disks. If
the performance counters weren't enabled, you had to run
diskperf and reboot - not good for a production server.
You can run diskperf /help from the command line and read
the comments. That's one area of "documentation" on it - for
whatever that's worth. But the output is along the lines of:
NOTE: Disk performance counters are permanently enabled on
systems beyond Windows 2000.
-Sue
On Tue, 10 Oct 2006 22:13:01 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello Sue,
>Thank you for the reply.
>Yes. They are automatically enabled - I came across that from an article.
>But I'm not able to find anything that will allow me to disable them
>(individually).
>I'm executing certain tests for an application one of which requires that
>these counters be disabled.
>Is there any specific reason for Windows Server 2003 Standard Edition to
>prevent the enabling/disabling of these counters? Can you point me to some
>literature regarding this. I can accept the fact that this kind of behaviou
r
>is not allowed - but need to know why - so that I provide a technical/logic
al
>reason.
>Cheers!
>sqlcatz|||Thank you Sue!
sqlcatz
Diskperf on Windows Server 2003 Standard Edition.
Hello,
I'm using Windows Server 2003 Standard Edition which has multiple instances
of SQL Server 2005 standard edition. Am running a few tests that require the
switching on/off of the physical & logical disk counters.
Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
Either both (Logical & Physical) are enabled or both are disabled.
How can I turn them on/off individually?
Cheers!
SqlcatzThe implementation of this changed on Windows 2003. Both
logical and physical are automatically enabled "on demand"
under Win 2003.
-Sue
On Mon, 9 Oct 2006 03:51:02 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>I'm using Windows Server 2003 Standard Edition which has multiple instances
>of SQL Server 2005 standard edition. Am running a few tests that require the
>switching on/off of the physical & logical disk counters.
>Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
>Either both (Logical & Physical) are enabled or both are disabled.
>How can I turn them on/off individually?
>Cheers!
>Sqlcatz|||Hello Sue,
Thank you for the reply.
Yes. They are automatically enabled - I came across that from an article.
But I'm not able to find anything that will allow me to disable them
(individually).
I'm executing certain tests for an application one of which requires that
these counters be disabled.
Is there any specific reason for Windows Server 2003 Standard Edition to
prevent the enabling/disabling of these counters? Can you point me to some
literature regarding this. I can accept the fact that this kind of behaviour
is not allowed - but need to know why - so that I provide a technical/logical
reason.
Cheers!
sqlcatz|||The are enabled when an application calls them - it's
automatic and built into the OS.
Previously, there were problems when you would have a
production performance issue and needed to monitor disks. If
the performance counters weren't enabled, you had to run
diskperf and reboot - not good for a production server.
You can run diskperf /help from the command line and read
the comments. That's one area of "documentation" on it - for
whatever that's worth. But the output is along the lines of:
NOTE: Disk performance counters are permanently enabled on
systems beyond Windows 2000.
-Sue
On Tue, 10 Oct 2006 22:13:01 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello Sue,
>Thank you for the reply.
>Yes. They are automatically enabled - I came across that from an article.
>But I'm not able to find anything that will allow me to disable them
>(individually).
>I'm executing certain tests for an application one of which requires that
>these counters be disabled.
>Is there any specific reason for Windows Server 2003 Standard Edition to
>prevent the enabling/disabling of these counters? Can you point me to some
>literature regarding this. I can accept the fact that this kind of behaviour
>is not allowed - but need to know why - so that I provide a technical/logical
>reason.
>Cheers!
>sqlcatz|||Thank you Sue!
sqlcatz
I'm using Windows Server 2003 Standard Edition which has multiple instances
of SQL Server 2005 standard edition. Am running a few tests that require the
switching on/off of the physical & logical disk counters.
Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
Either both (Logical & Physical) are enabled or both are disabled.
How can I turn them on/off individually?
Cheers!
SqlcatzThe implementation of this changed on Windows 2003. Both
logical and physical are automatically enabled "on demand"
under Win 2003.
-Sue
On Mon, 9 Oct 2006 03:51:02 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>I'm using Windows Server 2003 Standard Edition which has multiple instances
>of SQL Server 2005 standard edition. Am running a few tests that require the
>switching on/off of the physical & logical disk counters.
>Diskperf on Windows Server 2003 Standard Edition does not allow me to do this.
>Either both (Logical & Physical) are enabled or both are disabled.
>How can I turn them on/off individually?
>Cheers!
>Sqlcatz|||Hello Sue,
Thank you for the reply.
Yes. They are automatically enabled - I came across that from an article.
But I'm not able to find anything that will allow me to disable them
(individually).
I'm executing certain tests for an application one of which requires that
these counters be disabled.
Is there any specific reason for Windows Server 2003 Standard Edition to
prevent the enabling/disabling of these counters? Can you point me to some
literature regarding this. I can accept the fact that this kind of behaviour
is not allowed - but need to know why - so that I provide a technical/logical
reason.
Cheers!
sqlcatz|||The are enabled when an application calls them - it's
automatic and built into the OS.
Previously, there were problems when you would have a
production performance issue and needed to monitor disks. If
the performance counters weren't enabled, you had to run
diskperf and reboot - not good for a production server.
You can run diskperf /help from the command line and read
the comments. That's one area of "documentation" on it - for
whatever that's worth. But the output is along the lines of:
NOTE: Disk performance counters are permanently enabled on
systems beyond Windows 2000.
-Sue
On Tue, 10 Oct 2006 22:13:01 -0700, SQLCatz
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello Sue,
>Thank you for the reply.
>Yes. They are automatically enabled - I came across that from an article.
>But I'm not able to find anything that will allow me to disable them
>(individually).
>I'm executing certain tests for an application one of which requires that
>these counters be disabled.
>Is there any specific reason for Windows Server 2003 Standard Edition to
>prevent the enabling/disabling of these counters? Can you point me to some
>literature regarding this. I can accept the fact that this kind of behaviour
>is not allowed - but need to know why - so that I provide a technical/logical
>reason.
>Cheers!
>sqlcatz|||Thank you Sue!
sqlcatz
2012年3月22日星期四
Disester Recovery
Hi,
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as well
as DR Site?
Please let me know..
regards,
Mahmud
Hi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud
|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site. If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
>
>
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as well
as DR Site?
Please let me know..
regards,
Mahmud
Hi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud
|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site. If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
>
>
Disester Recovery
Hi,
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as well
as DR Site?
Please let me know..
regards,
MahmudHi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site. If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> > Hi,
> >
> > I'm using SQL Server 2000 Standard Edition and now I want to create a
> > Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> > edition? For info, I'm running a Financial Software, which means data
> > transection rate is very high. Another thing is that, for my remote users
> > what would be the minimum bandwidth required to connect to SQL Server as
> > well
> > as DR Site?
> >
> > Please let me know..
> >
> > regards,
> >
> > Mahmud
>
>
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as well
as DR Site?
Please let me know..
regards,
MahmudHi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site. If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> > Hi,
> >
> > I'm using SQL Server 2000 Standard Edition and now I want to create a
> > Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> > edition? For info, I'm running a Financial Software, which means data
> > transection rate is very high. Another thing is that, for my remote users
> > what would be the minimum bandwidth required to connect to SQL Server as
> > well
> > as DR Site?
> >
> > Please let me know..
> >
> > regards,
> >
> > Mahmud
>
>
Disester Recovery
Hi,
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as wel
l
as DR Site?
Please let me know..
regards,
MahmudHi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site.
If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
>
>
I'm using SQL Server 2000 Standard Edition and now I want to create a
Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
edition? For info, I'm running a Financial Software, which means data
transection rate is very high. Another thing is that, for my remote users
what would be the minimum bandwidth required to connect to SQL Server as wel
l
as DR Site?
Please let me know..
regards,
MahmudHi,
You can wither use
1. Logshipping
2. TRansactional Replication
But all depends up on the network speed between your location to DR site. If
you have a dedicated network connectivity
then you can setup a Transactional replication.
Regarding the bandwidth -- Depends up on the transacgtion and amount of
users connecting to your system. I recommend that you should
have identical network band width for both production and DR site
Thanks
Hari
SQL Server MVP
"Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
> Hi,
> I'm using SQL Server 2000 Standard Edition and now I want to create a
> Disester Recovery Site. Can I do that using that SQL Server 2000 Standard
> edition? For info, I'm running a Financial Software, which means data
> transection rate is very high. Another thing is that, for my remote users
> what would be the minimum bandwidth required to connect to SQL Server as
> well
> as DR Site?
> Please let me know..
> regards,
> Mahmud|||Hi
Thanks for the info. Can you please provide me some technical doc links, so
that I can get a better idea & can able to create/manage DR site.
Thanks once again.
"Hari Prasad" wrote:
> Hi,
> You can wither use
> 1. Logshipping
> 2. TRansactional Replication
> But all depends up on the network speed between your location to DR site.
If
> you have a dedicated network connectivity
> then you can setup a Transactional replication.
> Regarding the bandwidth -- Depends up on the transacgtion and amount of
> users connecting to your system. I recommend that you should
> have identical network band width for both production and DR site
> Thanks
> Hari
> SQL Server MVP
> "Mahmud" <Mahmud@.discussions.microsoft.com> wrote in message
> news:B6058E06-B1F7-45B7-A8E2-1ED6D83B6022@.microsoft.com...
>
>
2012年3月20日星期二
disconnection of web pages from SQL Server
We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)
Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
sql
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)
Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
sql
disconnection of web pages from SQL Server
We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
disconnection of web pages from SQL Server
We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front en
d
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (trie
s
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was lookin
g
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now
)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
[vbcol=seagreen]
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a col
d
> fusion application that is running against this database. We have 5 front
end
> (cold fusion) servers load balanced. We have a monitoring service that pin
gs
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tr
ies
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was look
ing
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory w
as
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was reall
y
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)[/vbc
ol]
fusion application that is running against this database. We have 5 front en
d
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (trie
s
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was lookin
g
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now
)Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:
[vbcol=seagreen]
> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a col
d
> fusion application that is running against this database. We have 5 front
end
> (cold fusion) servers load balanced. We have a monitoring service that pin
gs
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tr
ies
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was look
ing
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory w
as
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was reall
y
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)[/vbc
ol]
2012年3月11日星期日
Disaster Recovery: SQL Server 2000 on Win 2000 Server.
This past Monday, our Raid 5 array failed on our SQL 2000 server (standard edition). Long story short, we were able to get the data back, mostly. In SQL server Ent. Mgr., I had to restore 4 databases that were 'Suspect' and "greyed out". No problems there... I was able to restore them.
What was interesting was that the SQL Server Agent would not start. As it turned out, a few files were either corrupt or missing after we got the machine back up. We had to restore a few files from tape backup and now the SQL Server Agent starts... but now I have a new problem.
For some reason, my default SQL Server Agent "Job" that is scheduled to run once per day fails. It appears that all of the databases get backed up, but for some reason, the msdbdata.mdf database is NOT being backed up.
I have a few questions. Could my msdbdata.mdf be corrupt? I have a successful backup of the msdbdata.mdf table from 9/10/2007. Can I just restore from that? Will there be any repercussions to any of the other database tables if I do?
Furthermore, should I just restore the msdbdata.mdf, master.mdf and the model.mdf? I really have no idea what these tables do and the repercussions of modifying them. I am not a DBA (obviously) and I just don't want to make an mistakes.
Thanks, CFDev.
Can you pls provide the details of the job history if any ? I guess you mean to say that msdb database backup fails if i interpret it correctly 
and Yes you can go ahead and restore the msdb.bak dated 9/10/2007 and check........the only issue is that all the jobs,dts packages created since 9/10 will not be available if you restore it.........I don't think its needed its enough if you restore msdb no need to restore master or model dbs..........
|||The "Job" is part of the databases default "maintenance plan". It consists of four parts:
1. DB backup
2. Integrity checks
3. Optimizations
4. Transaction Log Backup
This should be familiar to you, no? Anyway, would be okay to restore the msdb database then? How about the model and master databases? No tables, stored procedures, dts packages or anything has been changed. I just want peace of mind that if I were to restore any of these database tables, it would not effect any of my website's database tables. Make sense?
|||
Yes i am familiar with it if you feel there is no change done in msdb after 9/10 you can go ahead and restore msdb. Master stores all the login information and model acts as
template for other dbs so just restore msdb as it contains all the jobs and dts packages....I dont think restoring msdb would affect your db tables.......
It would also be a good idea to run checkdb on all databases to make sure that they're clean.
You haven't made changes since 9/10, but you'd really rather not trip across hidden problems later.
Disaster Recovery: SQL Server 2000 on Win 2000 Server.
This past Monday, our Raid 5 array failed on our SQL 2000 server (standard edition). Long story short, we were able to get the data back, mostly. In SQL server Ent. Mgr., I had to restore 4 databases that were 'Suspect' and "greyed out". No problems there... I was able to restore them.
What was interesting was that the SQL Server Agent would not start. As it turned out, a few files were either corrupt or missing after we got the machine back up. We had to restore a few files from tape backup and now the SQL Server Agent starts... but now I have a new problem.
For some reason, my default SQL Server Agent "Job" that is scheduled to run once per day fails. It appears that all of the databases get backed up, but for some reason, the msdbdata.mdf database is NOT being backed up.
I have a few questions. Could my msdbdata.mdf be corrupt? I have a successful backup of the msdbdata.mdf table from 9/10/2007. Can I just restore from that? Will there be any repercussions to any of the other database tables if I do?
Furthermore, should I just restore the msdbdata.mdf, master.mdf and the model.mdf? I really have no idea what these tables do and the repercussions of modifying them. I am not a DBA (obviously) and I just don't want to make an mistakes.
Thanks, CFDev.
Can you pls provide the details of the job history if any ? I guess you mean to say that msdb database backup fails if i interpret it correctly and Yes you can go ahead and restore the msdb.bak dated 9/10/2007 and check........the only issue is that all the jobs,dts packages created since 9/10 will not be available if you restore it.........I don't think its needed its enough if you restore msdb no need to restore master or model dbs..........
|||The "Job" is part of the databases default "maintenance plan". It consists of four parts:
1. DB backup
2. Integrity checks
3. Optimizations
4. Transaction Log Backup
This should be familiar to you, no? Anyway, would be okay to restore the msdb database then? How about the model and master databases? No tables, stored procedures, dts packages or anything has been changed. I just want peace of mind that if I were to restore any of these database tables, it would not effect any of my website's database tables. Make sense?
|||
Yes i am familiar with it if you feel there is no change done in msdb after 9/10 you can go ahead and restore msdb. Master stores all the login information and model acts as
template for other dbs so just restore msdb as it contains all the jobs and dts packages....I dont think restoring msdb would affect your db tables.......
It would also be a good idea to run checkdb on all databases to make sure that they're clean.
You haven't made changes since 9/10, but you'd really rather not trip across hidden problems later.
Disaster Recovery - How to verify my 2005 standard databases using 2005 express
How to verify the "Full" backups of an online database.
Running MS SQL 2005 on Windows 2003 server using windows domain authentication
Obtaining nightly backups of the application databases & the system databases Installed MS SQL 2005 Express SP2 on a workstationMy task is to take the FULL BAK file(s) and recreate the database on the workstation for Disaster Recovery verification.
What parameters do I need to tweak? Do I need to import the System databases from the server? What security issues must be satisfied to connect on the new machine?
Good questions. I'll answer those below, but I wonder if another method might satisfy what you're really after. If you're looking for a standby system, then use Database Mirroring or Log Shipping or Clustering. All of these will fit the bill.
But on to your specific questions:
First, you can backup a SQL Server 2005 database on any edition and transfer it to another. Certain things work differently in certain editions however, such as replication, database mirroring and so on. You want to ensure that your applications don't depend on those features.
Second, Books Online has several references for moving system databases. Just search for "system databases" and you'll see what you need. It's important to note that you normally don't want to transfer your system databases to another server - the names of the servers and file locations will be different and so on. Backing them up is a good idea, but you don't want to transfer them.
Third, to connect to the second system, you'll need to fix the security in the database.
Buck Woody
|||How does one fix the security problems in the second server?Is there a formula or a list of parameters to change?|||Do a live.com search on "SQL Server Orphaned Accounts".|||In addition to Bucks comments refer these articles,
www.msdn2.microsoft.com/en-us/library/ms175475.aspx
http://sql-articles.com/articles.php?pageNum_alltop=1&totalRows_alltop=13
http://sql-articles.com/articles.php?pageNum_alltop=0&totalRows_alltop=13
http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html
Thanxx
Deepak
2012年3月8日星期四
Disappearing printer icon
I am finding that sometimes the RS web page displays a printer icon between
the refresh and help icons. This icon brings up a standard print dialog (when
the icon is there) which allows users to print to any of the printers
installed on their local system. It is definitely different than the printer
button on the browser. Reports print as though they were scheduled instead of
just rendered out of IE.
My question is, does anyone know why the icon only shows up on some
reporting services installations? It appears to be RS installation specific.
I get it when I connect to my local RS but when I connect to one on a 2000
server I do not.
TIA,
JimThe print icon was new in Service Pack 2. Is it possible that the server
hasn't had the upgrade?
"JimH" wrote:
> I am finding that sometimes the RS web page displays a printer icon between
> the refresh and help icons. This icon brings up a standard print dialog (when
> the icon is there) which allows users to print to any of the printers
> installed on their local system. It is definitely different than the printer
> button on the browser. Reports print as though they were scheduled instead of
> just rendered out of IE.
> My question is, does anyone know why the icon only shows up on some
> reporting services installations? It appears to be RS installation specific.
> I get it when I connect to my local RS but when I connect to one on a 2000
> server I do not.
> TIA,
> Jim
the refresh and help icons. This icon brings up a standard print dialog (when
the icon is there) which allows users to print to any of the printers
installed on their local system. It is definitely different than the printer
button on the browser. Reports print as though they were scheduled instead of
just rendered out of IE.
My question is, does anyone know why the icon only shows up on some
reporting services installations? It appears to be RS installation specific.
I get it when I connect to my local RS but when I connect to one on a 2000
server I do not.
TIA,
JimThe print icon was new in Service Pack 2. Is it possible that the server
hasn't had the upgrade?
"JimH" wrote:
> I am finding that sometimes the RS web page displays a printer icon between
> the refresh and help icons. This icon brings up a standard print dialog (when
> the icon is there) which allows users to print to any of the printers
> installed on their local system. It is definitely different than the printer
> button on the browser. Reports print as though they were scheduled instead of
> just rendered out of IE.
> My question is, does anyone know why the icon only shows up on some
> reporting services installations? It appears to be RS installation specific.
> I get it when I connect to my local RS but when I connect to one on a 2000
> server I do not.
> TIA,
> Jim
订阅：
博文 (Atom)