General discussion

Locked

Performance with VB & SQL server

By gberry ·
I am consulting with a large Life insurance organisation.

The environment is: Life administration system built in Visual Basic (with a little Vis Fox)on SQL server. The OS is Windows NT.

Currently we have one data & application serer, althoughwe are looking at moving to one for data, plus two or more for the aplication.

Current stress point id the batch processing, which is taking 5 hours, and added to the backups look to fill our batch window. Online performance is fine, however, itobviously must not suffer.

The question is:
Where should we be looking to improve performance, and what would you use to measure performance?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Performance with VB & SQL server

by True_Texan In reply to Performance with VB & SQL ...

It really depends on where your bottlenecks are. The most common bottleneck is disk activity. You may be able to overcome this by replacing the data disk drives (bump them from 7200 to 10K drives). Or you may want to investigate the possibility of using a Storage Area Network (SAN) rather than another standard RAID device. SQL server should be able to provide statistics on how well the database is running, and whether or not SQL is waiting on disk activity.

Another place look is the memory on the server. If you have unusually high page swapping going on (I think the rule is more than 8 pages per second per CPU), you may need to add more memory. Page swapping not only slows things down, but again, can degrade your disk I/O if your swap files are on the same channel as your data files.

Also take a look at how well your processor(s) are running. If they are maxed out most of the time, you may need to upgrade to a box that will support more processors.

Look at some of the technical articles that Microsoft has published on SQL server 2000 running on Windows 2000. From what Microsoft says, SQL 2000 handles most processes more efficiently, and, running on Windows 2000, can access up to 6GB of memory.

Hope this helps.

Collapse -

Performance with VB & SQL server

by gberry In reply to Performance with VB & SQL ...

The question was auto-closed by TechRepublic

Collapse -

Performance with VB & SQL server

by 20 + years In reply to Performance with VB & SQL ...

An additional thought. What is the timeliness of the data needed by the batch program? Are you running reports or batch updates? If only reports you can make a copy of the DB and run the batch reports off-line.

Collapse -

Performance with VB & SQL server

by gberry In reply to Performance with VB & SQL ...

The question was auto-closed by TechRepublic

Collapse -

Performance with VB & SQL server

by gberry In reply to Performance with VB & SQL ...

This question was auto closed due to inactivity

Back to IT Employment Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums