We've developed a number of SQL Server applications using Delphi 5. We run them from clients accessing our SQL Server install on our network server. We've recently had problems with our server and had to re-install SQL server. Since this re-install we've noticed an apparent loss of speed in the access of data through our applications.
We work through Delphi TDatabase components making use of ODBC connections from the client to the server.
I'm interested in testing the speed of connections from clients to our server. Is there a simple command we can use from each client to determine the speed of access to our SQL Server ?
Alternatively is there a simple application we can put together to achive this goal ?
What is an acceptable speed of connection from a client to a SQL Server sitting on a network server ?
Is there any way in which we can increase the performance by performing tweaks at the SQL Server level ?
Any help would be appreciated.
Thanks in advance.
Steve
We work through Delphi TDatabase components making use of ODBC connections from the client to the server.
I'm interested in testing the speed of connections from clients to our server. Is there a simple command we can use from each client to determine the speed of access to our SQL Server ?
Alternatively is there a simple application we can put together to achive this goal ?
What is an acceptable speed of connection from a client to a SQL Server sitting on a network server ?
Is there any way in which we can increase the performance by performing tweaks at the SQL Server level ?
Any help would be appreciated.
Thanks in advance.
Steve
