Re: Why the performace differs?


"Mohamed Gad" <mohamed.gad@xxxxxxxxx> wrote in message
news:7RYQe.1422$yn2.1342@xxxxxxxxxxxxxxxxxx
>
>
> >Does one have logging enabled and the other doesn't?
>
> How would i know weather the Logging is enabled or not?

Go into Enterprise manager and check the properties of the DB.

It should be FULL, Bulk Logged or Simple.


>
>
>
> >What about the disk subsystem?
> I don't get it.. do you mean the
> FAT Type if so? Both are NTFS Partitions

No, I mean the layout and type of disks.

RAID vs non-RAID (and type of RAID).

ATA vs SATA vs SCSI etc.

Log files on same physical drive(s) as data files. Location of temp db?

>
> Thank you soo much for your reply, but, I hope i would find a solution.

Well, we're trying to help.


>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)
  • Re: RAID Configuration
    ... performance) for the transaction log files to be on the RAID 1 set (which ... has faster write speeds than RAID 5) and the data files to be on the RAID 5 ... > one can occur you want the tran logs to operate as smoothly as possible. ...
    (microsoft.public.sqlserver.setup)
  • Re: RAID Configuration
    ... What you want on the Raid 1 are the SQL Server ... occur you want the tran logs to operate as smoothly as possible. ... you can move the log files later on. ...
    (microsoft.public.sqlserver.setup)
  • Re: Physical Disk Fragmentation
    ... Thanks I will try the raid 1 for the log files, ... I need to take sql offline to defrag? ...
    (microsoft.public.sqlserver.server)
  • Re: RAID Configuration
    ... > performance) for the transaction log files to be on the RAID 1 set (which ... > has faster write speeds than RAID 5) and the data files to be on the RAID ... What you want on the Raid 1 are the SQL Server ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)