|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Performance - php scriptsA vendor wrote a php script to manipulate date within SQL Server, basically
process data from 1 table and copy the data to multiple tables within the same server. He said the preformance for others client run really fast, except for ours. Our process run about 1 record (40 fields) per second. for table with 200K records, processing time is more than 8 hours, this is unexceptable for our environment. I am trying to figure out what I need to do within SQL server to speed up the process. Truncate log or Transactions? Any help is greatly appreciate? Thanks, Culam 8 Hours for 200K rows. That must be some really poor script. I don't know
what it is doing but it should only take a few minutes if done correctly. Without seeinghte code it is pretty hard to say. One thing that when you are doing a lot of data manipulation you should ensure you have plenty of room in the log file and it should be placed on a different drive array than the data file. Preferably a Raid 1. -- Show quoteAndrew J. Kelly SQL MVP "culam" <cu***@discussions.microsoft.com> wrote in message news:465DB2E9-14AA-4AE2-B83F-A79C73458BD3@microsoft.com... >A vendor wrote a php script to manipulate date within SQL Server, basically > process data from 1 table and copy the data to multiple tables within the > same server. He said the preformance for others client run really fast, > except for ours. Our process run about 1 record (40 fields) per second. > for > table with 200K records, processing time is more than 8 hours, this is > unexceptable for our environment. > I am trying to figure out what I need to do within SQL server to speed up > the process. > Truncate log or Transactions? > Any help is greatly appreciate? > Thanks, > Culam > Unfortunately, we don't have access to the codes and the Client insists there
codes is not the problem. How can I verify if log file is the problem? Culam Show quote "Andrew J. Kelly" wrote: > 8 Hours for 200K rows. That must be some really poor script. I don't know > what it is doing but it should only take a few minutes if done correctly. > Without seeinghte code it is pretty hard to say. One thing that when you are > doing a lot of data manipulation you should ensure you have plenty of room > in the log file and it should be placed on a different drive array than the > data file. Preferably a Raid 1. > > -- > Andrew J. Kelly SQL MVP > > > "culam" <cu***@discussions.microsoft.com> wrote in message > news:465DB2E9-14AA-4AE2-B83F-A79C73458BD3@microsoft.com... > >A vendor wrote a php script to manipulate date within SQL Server, basically > > process data from 1 table and copy the data to multiple tables within the > > same server. He said the preformance for others client run really fast, > > except for ours. Our process run about 1 record (40 fields) per second. > > for > > table with 200K records, processing time is more than 8 hours, this is > > unexceptable for our environment. > > I am trying to figure out what I need to do within SQL server to speed up > > the process. > > Truncate log or Transactions? > > Any help is greatly appreciate? > > Thanks, > > Culam > > > > > I doubt that is the case but anyway here are some links that may help you
pinpoint what the bottlenecks are. http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp Performance WP's http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters http://www.sql-server-performance.com/sql_server_performance_audit.asp Hardware Performance CheckList http://www.sql-server-performance.com/best_sql_server_performance_tips.asp SQL 2000 Performance tuning tips http://www.support.microsoft.com/?id=q224587 Troubleshooting App Performance http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp Disk Monitoring -- Show quoteAndrew J. Kelly SQL MVP "culam" <cu***@discussions.microsoft.com> wrote in message news:ED0F7189-D1C3-4B41-98EE-22F91FCCDB14@microsoft.com... > Unfortunately, we don't have access to the codes and the Client insists > there > codes is not the problem. > How can I verify if log file is the problem? > > Culam > > "Andrew J. Kelly" wrote: > >> 8 Hours for 200K rows. That must be some really poor script. I don't >> know >> what it is doing but it should only take a few minutes if done correctly. >> Without seeinghte code it is pretty hard to say. One thing that when you >> are >> doing a lot of data manipulation you should ensure you have plenty of >> room >> in the log file and it should be placed on a different drive array than >> the >> data file. Preferably a Raid 1. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "culam" <cu***@discussions.microsoft.com> wrote in message >> news:465DB2E9-14AA-4AE2-B83F-A79C73458BD3@microsoft.com... >> >A vendor wrote a php script to manipulate date within SQL Server, >> >basically >> > process data from 1 table and copy the data to multiple tables within >> > the >> > same server. He said the preformance for others client run really >> > fast, >> > except for ours. Our process run about 1 record (40 fields) per >> > second. >> > for >> > table with 200K records, processing time is more than 8 hours, this is >> > unexceptable for our environment. >> > I am trying to figure out what I need to do within SQL server to speed >> > up >> > the process. >> > Truncate log or Transactions? >> > Any help is greatly appreciate? >> > Thanks, >> > Culam >> > >> >> >>  |
|||||||||||||||||||||||
Other interesting topics