Re: A *particular* app running slowly?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Peter wrote:
Bob I <birelan@xxxxxxxxx> wrote
FWIW Writing would cause the database file to get larger. As to the
thrashing, perhaps PIO mode is being used as opposed to DMA.
The Properties for the SATA controller say that DMA modes are enabled,
and other applications are not showing a slowdown. For example I can
copy over a 600MB file from C: to D: (both on the same SATA-300
7200rpm drive; actually a mirror raid system comprising of 2 physical
300GB drives) in 50 secs, which is completely reasonable.
The 'database' is also not really a database; it is just a load of
files, each one containing the messages for each folder in Agent. And
I am not a big Usenet user so don't have millions of messages. This
data was moved to this PC from a previous Win2000 PC, using simple
copy. Agent itself was of course reinstalled fresh.
I did move the database to another partition but it runs the same way:
very slow write operations.
I will next try creating a tiny FAT32 partition (I think there is an
unused 1GB at the end of the hard drive) and see if that helps.
Certainly sounds like the hardware and file system are not the cause of
the issue. Any kind of ongoing virus scan or indexing set to check or
scan the database files?
.
Relevant Pages
- Re: [BUG] kernel 2.6.15.4: soft lockup detected on CPU#0!
... PIO mode, which is the case for Folkert van Heusden, who reported the ... However it does not appear that my cdrom drives are using PIO, ... logs i have they're supposed to use DMA: ... DMA modes: mdma0 mdma1 mdma2 ...
(Linux-Kernel) - Re: Cool boat & travel computer
... For the "new" PCXT, the biggest FULL HEIGHT hard drive was the Tulin ... drives and 256K of RAM. ... these nice 9-track drives with bus adapter cards and drivers in Computer ... run the custom database, print perfect Meter Cards so the technicians on ...
(rec.boats.cruising) - Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
(microsoft.public.sqlserver.setup) - Re: File Corruption
... No one in the 3 institutions have access to their PC's hard drives. ... The "My Documents" is actually a spot on a network drive called the H ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ...
(microsoft.public.access.gettingstarted) - Re: File Corruption
... No one in the 3 institutions have access to their PC's hard drives. ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ... single shared copy of a front end on a network, ...
(microsoft.public.access.gettingstarted) |
|
