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

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 Cárdenas
SQL Server senior support professional

.net framework version

We have an application that requires a different version of .net framework
(not 2.0). Can the SQL Server 2005 client tools be installed with a different
version of .net framework? I would rather the programmers use the SQL 2005
tools instead of SQL 2000.
Thanks.
Esteban Arturo
SQL Server tools require 2.0 but you can have multiple versions of the .NET
Framework installed so installing SQL Server doesn't limit your ability to
use the older version of the framework.
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"Esteban Arturo" <EstebanArturo@.discussions.microsoft.com> wrote in message
news:30738F85-0D35-41B4-9E76-BDA05A96B1B7@.microsoft.com...
> We have an application that requires a different version of .net framework
> (not 2.0). Can the SQL Server 2005 client tools be installed with a
> different
> version of .net framework? I would rather the programmers use the SQL 2005
> tools instead of SQL 2000.
> Thanks.
> --
> Esteban Arturo