var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hi DB gurus,
Since tempdb & log of a database is operating system file in SQL Server 2000, I was wondering what are the ways & means to improve performance. There are number of times the queries uses tempdb. Similarly log device are heavily used too.
Any help, pointers will be much appreciated.
In general, try to avoid using temp table as much as possible. You can read more about it from the URL below:
In addition, you should put the Tempdb, Log, and data file each on separate disk on DIFFERENT controllers if possible. These steps will definitely 90% improve the database ovcerall performance.
... true by all means, also check this link.
Microsoft SQL Server MVP
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors