MS SQL Server - Slow SQL Server

Author

Slow SQL Server

Islamegy®

2006-02-11, 7:23 am

We have upgraded From Win2000 Server to Win2003 Standard
with sql server2000 SP4.. after upgrade all our program which connect to the
server is too slow.. doing update or save operation on a table with 100,000
record talk 5 sec or more if few people work on the same table, with the old
windows version there was no such delay..
The machine is Intel 3.2G/2MB Cach, 2 GB DDRam 2 Dual channel.. Gigabyte
motherboard Intel 945.
Any help please, it was a nightmare upgrade!!

James Wilson

2006-02-11, 7:23 am

Islamegy® wrote:
> We have upgraded From Win2000 Server to Win2003 Standard
> with sql server2000 SP4.. after upgrade all our program which connect to the
> server is too slow.. doing update or save operation on a table with 100,000
> record talk 5 sec or more if few people work on the same table, with the old
> windows version there was no such delay..
> The machine is Intel 3.2G/2MB Cach, 2 GB DDRam 2 Dual channel.. Gigabyte
> motherboard Intel 945.
> Any help please, it was a nightmare upgrade!!
>
>
Hi Islamegy,
Have you intergrated SQLServer with Active Directory?

James

Islamegy®

2006-02-11, 9:23 am

We don't have domain.. We are working in simple workgroup enviroment.. the
main reason we did this upgrade is performance!!

"James Wilson" < JamesWilson@bryggema
il.dk> wrote in message
news:u2TEqGwLGHA.536@TK2MSFTNGP09.phx.gbl...
> Islamegy® wrote:
> Hi Islamegy,
> Have you intergrated SQLServer with Active Directory?
>
> James

Andrew J. Kelly

2006-02-11, 9:23 am

Have you looked to see where the bottleneck really is? It sounds like this
is a bare bones system and if you have 5 concurrent users doing heavy access
you may need to make some more changes. Is your log and data files both on
the same physical disk drive? Do you have proper indexes on the table?
Upgrading to Win2003 will not solve problems that are a result of a poorly
optimized application and database. It may have made things worse in some
areas because it could have alleviated a bottleneck in other areas and
exposing a new one.

http://www.sql-server-performance.c... ce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pr...operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c.../> ce_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d...erfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types

--
Andrew J. Kelly SQL MVP

"Islamegy®" < NULL_Islamegy_NULL@y
ahoo.com> wrote in message
news:%23TfyR6wLGHA.2300@TK2MSFTNGP15.phx.gbl...
> We don't have domain.. We are working in simple workgroup enviroment.. the
> main reason we did this upgrade is performance!!
>
> "James Wilson" < JamesWilson@bryggema
il.dk> wrote in message
> news:u2TEqGwLGHA.536@TK2MSFTNGP09.phx.gbl...
>
>

jkane@satx.rr.com

2006-02-11, 11:23 am

I am curious...why would integration with active directory matter?
There is nothing in the original post to suggest a connection problem.
What do you know that I dont?
Jim Kane

Islamegy®

2006-02-11, 11:23 am

I was't have a real problem with old windows.. the performace was great..
All my index is optmized and everything was working great on win2000
server..

when we was upgrade i took a copy of the Data Folder and after Reinstall SQL
Server and apply SP4.. I copied it back with all system & users databases..
(the old Server was SP4 too)
any help??

"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:eo$stlxLGHA.3708@TK2MSFTNGP09.phx.gbl...
> Have you looked to see where the bottleneck really is? It sounds like
> this is a bare bones system and if you have 5 concurrent users doing heavy
> access you may need to make some more changes. Is your log and data files
> both on the same physical disk drive? Do you have proper indexes on the
> table? Upgrading to Win2003 will not solve problems that are a result of a
> poorly optimized application and database. It may have made things worse
> in some areas because it could have alleviated a bottleneck in other areas
> and exposing a new one.
>
> http://www.sql-server-performance.c... ce_audit10.asp
> Performance Audit
> http://www.microsoft.com/technet/pr...operations.mspx
> Performance WP's
> http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
> http://www.sql-server-performance.c.../> ce_audit.asp
> hardware Performance CheckList
> http://www.sql-server-performance.c...rmance_tips.asp
> SQL 2000 Performance tuning tips
> http://www.support.microsoft.com/?id=224587 Troubleshooting App
> Performance
> http://msdn.microsoft.com/library/d...erfmon_24u1.asp
> Disk Monitoring
> http://sqldev.net/misc/WaitTypes.htm Wait Types
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Islamegy®" < NULL_Islamegy_NULL@y
ahoo.com> wrote in message
> news:%23TfyR6wLGHA.2300@TK2MSFTNGP15.phx.gbl...
>
>

Andrew J. Kelly

2006-02-11, 8:23 pm

Copying the folders is certainly not the recommended way to restore your
data. See the links below. But in any case did you run sp_updatestatistics
after you brought everything back up? If not try running it and see if that
helps. If not you need to see where the bottleneck is now.

http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...irdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000

--
Andrew J. Kelly SQL MVP

"Islamegy®" < NULL_Islamegy_NULL@y
ahoo.com> wrote in message
news:uPTJ5RyLGHA.4064@TK2MSFTNGP10.phx.gbl...
>I was't have a real problem with old windows.. the performace was great..
>All my index is optmized and everything was working great on win2000
>server..
>
> when we was upgrade i took a copy of the Data Folder and after Reinstall
> SQL Server and apply SP4.. I copied it back with all system & users
> databases.. (the old Server was SP4 too)
> any help??
>
>
>
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:eo$stlxLGHA.3708@TK2MSFTNGP09.phx.gbl...
>
>

Sponsored Links