CAn anyone give me tips about what to analyse on a databse
that is in developmente before entering production.. i
already used both microsoft tools BPS and MSBA... anything
else?
> CAn anyone give me tips about what to analyse on a databse
> that is in developmente before entering production.. i
> already used both microsoft tools BPS and MSBA... anything
> else?
>
You should also use SQLIOStress tool to ensure that your hardware can cope
with typical load from SQL Server.
Checkout this article:
HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such As SQL
Server
http://support.microsoft.com/?id=231619
Hope this helps,
Eric Crdenas
SQL Server senior support professional

CAn anyone give me tips about what to analyse on a databse
that is in developmente before entering production.. i
already used both microsoft tools BPS and MSBA... anything
else?> CAn anyone give me tips about what to analyse on a databse
> that is in developmente before entering production.. i
> already used both microsoft tools BPS and MSBA... anything
> else?
>
--
You should also use SQLIOStress tool to ensure that your hardware can cope
with typical load from SQL Server.
Checkout this article:
HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such As SQL
Server
http://support.microsoft.com/?id=231619
Hope this helps,
Eric Crdenas
SQL Server senior support professional