Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.
in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.
2012年3月8日星期四
Any side effects from backing up DB and log at the same time?
Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.
Any side effects from backing up DB and log at the same time?
Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.
2012年2月23日星期四
any impact if create index and then drop index
hi,
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?
On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.4ax.com... [vbcol=seagreen]
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
the
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?
On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.4ax.com... [vbcol=seagreen]
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
the
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
any impact if create index and then drop index
hi,
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.
4ax.com...
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>
the[vbcol=seagreen]
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.
4ax.com...
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>
the[vbcol=seagreen]
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
any impact if create index and then drop index
hi,
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.4ax.com...
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
> >hi,
> >
> >i want to create index to speed up one operation (DELETE) and the drop
the
> >index to resume.
> >
> >any side effects or impacts on the db?
> >
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
i want to create index to speed up one operation (DELETE) and the drop the
index to resume.
any side effects or impacts on the db?On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
>hi,
>i want to create index to speed up one operation (DELETE) and the drop the
>index to resume.
>any side effects or impacts on the db?
>
Hi Mullin,
Creating the index will take some time and will also lock parts of your
data. Dropping the index doesn't take much time (unless it is a clustered
index).
However, why would you want to drop the index after the delete?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||because want to add an index on the third-party product for a temp
operation. don't know any impacts on that product if exist an index
persistently.
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:fkdoq0p5sb73abfmke0phv999kjaa2k4p9@.4ax.com...
> On Tue, 30 Nov 2004 15:34:47 +0800, Mullin Yu wrote:
> >hi,
> >
> >i want to create index to speed up one operation (DELETE) and the drop
the
> >index to resume.
> >
> >any side effects or impacts on the db?
> >
> Hi Mullin,
> Creating the index will take some time and will also lock parts of your
> data. Dropping the index doesn't take much time (unless it is a clustered
> index).
> However, why would you want to drop the index after the delete?
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Wed, 1 Dec 2004 15:47:04 +0800, Mullin Yu wrote:
>because want to add an index on the third-party product for a temp
>operation. don't know any impacts on that product if exist an index
>persistently.
Hi Mullin,
An extra index will:
* Slightly decrease performance of inserts, deletes and updates that
affect the column(s) used in the index,
* Speed up those queries that can use this index,
* Slightly increase the size of databases and backups,
* Have no effect on any other operation.
All this on the assumption that you're talking about a nonclustered index.
A clustered index has more impact. (But since building and dropping a
clustered index is quite costly, I don't think you'd consider this for
your temp index).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Any ill effects w/SP4
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan
If you are using AWE, you will need a post-SP4 hotfix.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan
|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>
|||Would be interested in hearing about noticed performance improvements as
well.
|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problems.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan
If you are using AWE, you will need a post-SP4 hotfix.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan
|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>
|||Would be interested in hearing about noticed performance improvements as
well.
|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problems.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
Any ill effects w/SP4
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
BryanIf you are using AWE, you will need a post-SP4 hotfix.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>|||Would be interested in hearing about noticed performance improvements as
well.|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problems.
Cheers, Massimo
--
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
Has anyone had any ill effects after applying SP4?
Thanks,
BryanIf you are using AWE, you will need a post-SP4 hotfix.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>|||Would be interested in hearing about noticed performance improvements as
well.|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problems.
Cheers, Massimo
--
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
Any ill effects w/SP4
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
BryanIf you are using AWE, you will need a post-SP4 hotfix.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>|||Would be interested in hearing about noticed performance improvements as
well.|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problem
s.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
Has anyone had any ill effects after applying SP4?
Thanks,
BryanIf you are using AWE, you will need a post-SP4 hotfix.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"BDB" <reply@.to.group.com> wrote in message
news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
Hi,
Has anyone had any ill effects after applying SP4?
Thanks,
Bryan|||Thanks. However, I was referring undocumented ones.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ub4EH%23kfFHA.1048@.tk2msftngp13.phx.gbl...
> If you are using AWE, you will need a post-SP4 hotfix.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "BDB" <reply@.to.group.com> wrote in message
> news:%23JBQa1kfFHA.3940@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Has anyone had any ill effects after applying SP4?
> Thanks,
> Bryan
>|||Would be interested in hearing about noticed performance improvements as
well.|||Well I can tell you that after installing SP4 complex queries were not
ending anymore (error 17883)...did not try to install post-fix for complex
query but I went back to SP3a ...
mem dumps + logs sended to PSS. Never got answer to our performances problem
s.
Cheers, Massimo
Software Engineer
TCF - Amsterdam (NL)
"BDB" wrote:
> Would be interested in hearing about noticed performance improvements as
> well.
>
>
订阅：
博文 (Atom)