I currently have SQL 2000 Standard on a box with a Single 2.4GHz Xeon HT
processor. Would my performance be better served by adding the 2nd CPU or
upgrading the current CPU to a 3.2GHz?
Any thoughts are welcome,
ScottGenerally I would go with a multi proc environment as you could
simultaneously serve mulitple requests faster although individual request ma
y
be served faster by increasing the clock speed of the single processor.
Licensing would also be a factor in my decision.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"Scott Cadreau" wrote:
> I currently have SQL 2000 Standard on a box with a Single 2.4GHz Xeon HT
> processor. Would my performance be better served by adding the 2nd CPU or
> upgrading the current CPU to a 3.2GHz?
> Any thoughts are welcome,
> Scott
>
>
Showing posts with label adding. Show all posts
Showing posts with label adding. Show all posts
Friday, March 23, 2012
Wednesday, March 21, 2012
Performance problems (strange)
Hello,
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.
What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com >
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>
|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com >
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
>
>
|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:[vbcol=seagreen]
> Selects are much slower. Also sql execution plan shown by query analyser is
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan are
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.
What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com >
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>
|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com >
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
>
>
|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:[vbcol=seagreen]
> Selects are much slower. Also sql execution plan shown by query analyser is
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan are
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
Performance problems (strange)
Hello,
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> > Hello,
> > I encounter serious performance degradation and what's more important -
> > strange SQL server behaviour after removing and adding again indexes on
> > few
> > (6-8) tables.
> > Let me explain - I have original database, which performs well. Database
> > size is about 400-600 MB on disk. Then I remove few indexes from few
> > tables
> > and add it again. Now database performs drastically slower. More than
> > that,
> > the query schema has changed after removal/adding indexes, but database
> > schema is the same! So it looks strange.
> > Please help me and explain why query schema has changed, while database
> > schema is unchanged? Why database performs slower?
> > I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> > scenarios, also with Windows Server 2003.
> > Adam.
> >
>
>|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:
> Selects are much slower. Also sql execution plan shown by query analyser is
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan are
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
>>What do you mean the query schema has changed? What is occurring slower?
>>(Selects? Updates? etc..)
>>
>>"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
>>wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
>>Hello,
>>I encounter serious performance degradation and what's more important -
>>strange SQL server behaviour after removing and adding again indexes on
>>few
>>(6-8) tables.
>>Let me explain - I have original database, which performs well. Database
>>size is about 400-600 MB on disk. Then I remove few indexes from few
>>tables
>>and add it again. Now database performs drastically slower. More than
>>that,
>>the query schema has changed after removal/adding indexes, but database
>>schema is the same! So it looks strange.
>>Please help me and explain why query schema has changed, while database
>>schema is unchanged? Why database performs slower?
>>I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
>>scenarios, also with Windows Server 2003.
>>Adam.
>>
>>sql
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> > Hello,
> > I encounter serious performance degradation and what's more important -
> > strange SQL server behaviour after removing and adding again indexes on
> > few
> > (6-8) tables.
> > Let me explain - I have original database, which performs well. Database
> > size is about 400-600 MB on disk. Then I remove few indexes from few
> > tables
> > and add it again. Now database performs drastically slower. More than
> > that,
> > the query schema has changed after removal/adding indexes, but database
> > schema is the same! So it looks strange.
> > Please help me and explain why query schema has changed, while database
> > schema is unchanged? Why database performs slower?
> > I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> > scenarios, also with Windows Server 2003.
> > Adam.
> >
>
>|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:
> Selects are much slower. Also sql execution plan shown by query analyser is
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan are
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
>>What do you mean the query schema has changed? What is occurring slower?
>>(Selects? Updates? etc..)
>>
>>"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
>>wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
>>Hello,
>>I encounter serious performance degradation and what's more important -
>>strange SQL server behaviour after removing and adding again indexes on
>>few
>>(6-8) tables.
>>Let me explain - I have original database, which performs well. Database
>>size is about 400-600 MB on disk. Then I remove few indexes from few
>>tables
>>and add it again. Now database performs drastically slower. More than
>>that,
>>the query schema has changed after removal/adding indexes, but database
>>schema is the same! So it looks strange.
>>Please help me and explain why query schema has changed, while database
>>schema is unchanged? Why database performs slower?
>>I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
>>scenarios, also with Windows Server 2003.
>>Adam.
>>
>>sql
Performance problems (strange)
Hello,
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com..
.
>
>|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:[vbcol=seagreen]
> Selects are much slower. Also sql execution plan shown by query analyser i
s
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan a
re
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
I encounter serious performance degradation and what's more important -
strange SQL server behaviour after removing and adding again indexes on few
(6-8) tables.
Let me explain - I have original database, which performs well. Database
size is about 400-600 MB on disk. Then I remove few indexes from few tables
and add it again. Now database performs drastically slower. More than that,
the query schema has changed after removal/adding indexes, but database
schema is the same! So it looks strange.
Please help me and explain why query schema has changed, while database
schema is unchanged? Why database performs slower?
I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
scenarios, also with Windows Server 2003.
Adam.What do you mean the query schema has changed? What is occurring slower?
(Selects? Updates? etc..)
"aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com...
> Hello,
> I encounter serious performance degradation and what's more important -
> strange SQL server behaviour after removing and adding again indexes on
> few
> (6-8) tables.
> Let me explain - I have original database, which performs well. Database
> size is about 400-600 MB on disk. Then I remove few indexes from few
> tables
> and add it again. Now database performs drastically slower. More than
> that,
> the query schema has changed after removal/adding indexes, but database
> schema is the same! So it looks strange.
> Please help me and explain why query schema has changed, while database
> schema is unchanged? Why database performs slower?
> I use SQL Srv 2000 SP3a, Win 2000Srv, 1 GB RAM. Tested in many hardware
> scenarios, also with Windows Server 2003.
> Adam.
>|||Selects are much slower. Also sql execution plan shown by query analyser is
different than on a original database.
So I have 2 databases, they have identical schema but SQL execution plan are
different and performance degraded on 2nd db.
Adam
"Jeff Fiegel" wrote:
> What do you mean the query schema has changed? What is occurring slower?
> (Selects? Updates? etc..)
>
> "aheczko@.nospam.nospam" <aheczko@.nospam.nospam@.discussions.microsoft.com>
> wrote in message news:D6E52964-B847-4DB7-BACD-CEA5A8BECB97@.microsoft.com..
.
>
>|||Adam,
Are you *sure* the indexes are the same as before? After rebuilding your
indexes run sp_updatestats.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
aheczko@.nospam.nospam wrote:[vbcol=seagreen]
> Selects are much slower. Also sql execution plan shown by query analyser i
s
> different than on a original database.
> So I have 2 databases, they have identical schema but SQL execution plan a
re
> different and performance degraded on 2nd db.
> Adam
> "Jeff Fiegel" wrote:
>
Subscribe to:
Posts (Atom)