Showing posts with label prod. Show all posts
Showing posts with label prod. Show all posts

Monday, March 26, 2012

Performance Developer vs. Std

We have a series of SPs, poorly written, but that's not the issue here.
Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
(Dev), dual P3, 2gig ram. Pretty much just DB servers.
But we've even tried the local Dasd on the Prod (Std) box.
The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
even everything on a single RAID drive. Prod at least has db and log
separate, more at times.
We've checked everything, and can't find any differences. Running on Prod
Off hours when it's not even breaking a sweat.
The proc does nothing special, except a cursor for Update (Ooouugghh).
Any ideas what to look at ? We compared everything we can think of, no
differences SQL, Win2000... No errors in the event log ..., Query plans
match even cost estimates.
Could Developer (which is Enterprise, right) provide that much boost vs.
Std, even with nothing, that I know of that would be using EE features.
Note to date everything I've wrritten, even some larger procs (10 to 20
million row processes) seem to run as expected. Slightly faster on Prod.
KlK, MCSE
Hi
As a good benchmark, run the SQL IO stress tools on your Dev and Production
server. It will indicate if your SAN is considerably slower than the local
drives.
Look at the links off http://msmvps.com/epprecht/archive/2.../24/10591.aspx
EE does have some performance enhancements over standard (pre-fetch) but the
Disk might be your issue.
Regards
Mike
"KevinK" wrote:

> We have a series of SPs, poorly written, but that's not the issue here.
> Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
> (Dev), dual P3, 2gig ram. Pretty much just DB servers.
> But we've even tried the local Dasd on the Prod (Std) box.
> The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
> even everything on a single RAID drive. Prod at least has db and log
> separate, more at times.
> We've checked everything, and can't find any differences. Running on Prod
> Off hours when it's not even breaking a sweat.
> The proc does nothing special, except a cursor for Update (Ooouugghh).
> Any ideas what to look at ? We compared everything we can think of, no
> differences SQL, Win2000... No errors in the event log ..., Query plans
> match even cost estimates.
> Could Developer (which is Enterprise, right) provide that much boost vs.
> Std, even with nothing, that I know of that would be using EE features.
> Note to date everything I've wrritten, even some larger procs (10 to 20
> million row processes) seem to run as expected. Slightly faster on Prod.
>
> --
> KlK, MCSE
|||Thanks Mike, unfortunately we have tested it using only the local drive on
Prod.
We have a 70gig local raid drive that is normally used for Backups etc.
It didn't help.
We do know the SAN drives are slower than locals, but it isn't that
significant, maybe 20% (I think 12 to 15 was the official number.
But when we run it on the SAN we are using multiple drives, log and data.
I am trying to get them to do a DBHammer
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> As a good benchmark, run the SQL IO stress tools on your Dev and Production
> server. It will indicate if your SAN is considerably slower than the local
> drives.
> Look at the links off http://msmvps.com/epprecht/archive/2.../24/10591.aspx
> EE does have some performance enhancements over standard (pre-fetch) but the
> Disk might be your issue.
> Regards
> Mike
> "KevinK" wrote:

Performance Developer vs. Std

We have a series of SPs, poorly written, but that's not the issue here.
Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
(Dev), dual P3, 2gig ram. Pretty much just DB servers.
But we've even tried the local Dasd on the Prod (Std) box.
The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
even everything on a single RAID drive. Prod at least has db and log
separate, more at times.
We've checked everything, and can't find any differences. Running on Prod
Off hours when it's not even breaking a sweat.
The proc does nothing special, except a cursor for Update (Ooouugghh).
Any ideas what to look at ' We compared everything we can think of, no
differences SQL, Win2000... No errors in the event log ..., Query plans
match even cost estimates.
Could Developer (which is Enterprise, right) provide that much boost vs.
Std, even with nothing, that I know of that would be using EE features.
Note to date everything I've wrritten, even some larger procs (10 to 20
million row processes) seem to run as expected. Slightly faster on Prod.
--
KlK, MCSEHi
As a good benchmark, run the SQL IO stress tools on your Dev and Production
server. It will indicate if your SAN is considerably slower than the local
drives.
Look at the links off http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx
EE does have some performance enhancements over standard (pre-fetch) but the
Disk might be your issue.
Regards
Mike
"KevinK" wrote:
> We have a series of SPs, poorly written, but that's not the issue here.
> Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
> (Dev), dual P3, 2gig ram. Pretty much just DB servers.
> But we've even tried the local Dasd on the Prod (Std) box.
> The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
> even everything on a single RAID drive. Prod at least has db and log
> separate, more at times.
> We've checked everything, and can't find any differences. Running on Prod
> Off hours when it's not even breaking a sweat.
> The proc does nothing special, except a cursor for Update (Ooouugghh).
> Any ideas what to look at ' We compared everything we can think of, no
> differences SQL, Win2000... No errors in the event log ..., Query plans
> match even cost estimates.
> Could Developer (which is Enterprise, right) provide that much boost vs.
> Std, even with nothing, that I know of that would be using EE features.
> Note to date everything I've wrritten, even some larger procs (10 to 20
> million row processes) seem to run as expected. Slightly faster on Prod.
>
> --
> KlK, MCSE|||Thanks Mike, unfortunately we have tested it using only the local drive on
Prod.
We have a 70gig local raid drive that is normally used for Backups etc.
It didn't help.
We do know the SAN drives are slower than locals, but it isn't that
significant, maybe 20% (I think 12 to 15 was the official number.
But when we run it on the SAN we are using multiple drives, log and data.
I am trying to get them to do a DBHammer
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> As a good benchmark, run the SQL IO stress tools on your Dev and Production
> server. It will indicate if your SAN is considerably slower than the local
> drives.
> Look at the links off http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx
> EE does have some performance enhancements over standard (pre-fetch) but the
> Disk might be your issue.
> Regards
> Mike
> "KevinK" wrote:
> > We have a series of SPs, poorly written, but that's not the issue here.
> >
> > Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
> > (Dev), dual P3, 2gig ram. Pretty much just DB servers.
> >
> > But we've even tried the local Dasd on the Prod (Std) box.
> >
> > The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
> > even everything on a single RAID drive. Prod at least has db and log
> > separate, more at times.
> >
> > We've checked everything, and can't find any differences. Running on Prod
> > Off hours when it's not even breaking a sweat.
> >
> > The proc does nothing special, except a cursor for Update (Ooouugghh).
> >
> > Any ideas what to look at ' We compared everything we can think of, no
> > differences SQL, Win2000... No errors in the event log ..., Query plans
> > match even cost estimates.
> >
> > Could Developer (which is Enterprise, right) provide that much boost vs.
> > Std, even with nothing, that I know of that would be using EE features.
> >
> > Note to date everything I've wrritten, even some larger procs (10 to 20
> > million row processes) seem to run as expected. Slightly faster on Prod.
> >
> >
> >
> > --
> > KlK, MCSEsql

Performance Developer vs. Std

We have a series of SPs, poorly written, but that's not the issue here.
Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
(Dev), dual P3, 2gig ram. Pretty much just DB servers.
But we've even tried the local Dasd on the Prod (Std) box.
The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
even everything on a single RAID drive. Prod at least has db and log
separate, more at times.
We've checked everything, and can't find any differences. Running on Prod
Off hours when it's not even breaking a sweat.
The proc does nothing special, except a cursor for Update (Ooouugghh).
Any ideas what to look at ' We compared everything we can think of, no
differences SQL, Win2000... No errors in the event log ..., Query plans
match even cost estimates.
Could Developer (which is Enterprise, right) provide that much boost vs.
Std, even with nothing, that I know of that would be using EE features.
Note to date everything I've wrritten, even some larger procs (10 to 20
million row processes) seem to run as expected. Slightly faster on Prod.
KlK, MCSEHi
As a good benchmark, run the SQL IO stress tools on your Dev and Production
server. It will indicate if your SAN is considerably slower than the local
drives.
Look at the links off [url]http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx[/ur
l]
EE does have some performance enhancements over standard (pre-fetch) but the
Disk might be your issue.
Regards
Mike
"KevinK" wrote:

> We have a series of SPs, poorly written, but that's not the issue here.
> Two machines, hardware identical, except mostly SAN (Prod) vs. Local Dasd
> (Dev), dual P3, 2gig ram. Pretty much just DB servers.
> But we've even tried the local Dasd on the Prod (Std) box.
> The process runs 2 1/2 to 3 hours on Dev, 9 to 10 on Prod. On Dev that's
> even everything on a single RAID drive. Prod at least has db and log
> separate, more at times.
> We've checked everything, and can't find any differences. Running on Prod
> Off hours when it's not even breaking a sweat.
> The proc does nothing special, except a cursor for Update (Ooouugghh).
> Any ideas what to look at ' We compared everything we can think of, no
> differences SQL, Win2000... No errors in the event log ..., Query plans
> match even cost estimates.
> Could Developer (which is Enterprise, right) provide that much boost vs.
> Std, even with nothing, that I know of that would be using EE features.
> Note to date everything I've wrritten, even some larger procs (10 to 20
> million row processes) seem to run as expected. Slightly faster on Prod.
>
> --
> KlK, MCSE|||Thanks Mike, unfortunately we have tested it using only the local drive on
Prod.
We have a 70gig local raid drive that is normally used for Backups etc.
It didn't help.
We do know the SAN drives are slower than locals, but it isn't that
significant, maybe 20% (I think 12 to 15 was the official number.
But when we run it on the SAN we are using multiple drives, log and data.
I am trying to get them to do a DBHammer
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> As a good benchmark, run the SQL IO stress tools on your Dev and Productio
n
> server. It will indicate if your SAN is considerably slower than the local
> drives.
> Look at the links off [url]http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx[/
url]
> EE does have some performance enhancements over standard (pre-fetch) but t
he
> Disk might be your issue.
> Regards
> Mike
> "KevinK" wrote:
>

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimD
On Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:

>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.
|||Hi Jim
"Jim Douglas" wrote:

> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blocking
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also check
index fragmentations and the validity of the statistics.
John

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimDOn Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:

>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.|||Hum., 20 minutes in DEV: with this kind of result, you shouldn't be
surprised to see the PROD to take much longer if its size is four times as
big.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
>|||"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
What is the query?
And what is the schema for the tables involved?
A 20 minute query is a pretty long query in most cases (but not all.)

> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
What made you decide to change this? Is this a datawarehouse or an OLTP.
In some cases 100% fill factor can make overall performance far worse.
(generally if yo're only selecting, it's great, you'll pack as much data
into the nodes of the b-tree as possible, but inserts will cost a lot more
overheard.)

> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
You running SQL 2000 or 2005?
> JimD
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Jim
"Jim Douglas" wrote:

> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access
.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blockin
g
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also chec
k
index fragmentations and the validity of the statistics.
John

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimDOn Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:
>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.|||Hum., 20 minutes in DEV: with this kind of result, you shouldn't be
surprised to see the PROD to take much longer if its size is four times as
big.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
>|||"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
What is the query?
And what is the schema for the tables involved?
A 20 minute query is a pretty long query in most cases (but not all.)
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
What made you decide to change this? Is this a datawarehouse or an OLTP.
In some cases 100% fill factor can make overall performance far worse.
(generally if yo're only selecting, it's great, you'll pack as much data
into the nodes of the b-tree as possible, but inserts will cost a lot more
overheard.)
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
You running SQL 2000 or 2005?
> JimD
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Jim
"Jim Douglas" wrote:
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blocking
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also check
index fragmentations and the validity of the statistics.
John