Friday, March 30, 2012

Launch SQL 2005 Database Tuning Advisor

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
with SQL
05 SP1. try to launch Database Tuning Advisor from the Tools, then got
the
following error message box:
"Microsoft Visual C++ Runtime Library
Runtime Error
R6031 - Attempt to initialize the CRT more than once. This indicates a
bug
in your application"
Find out KB 913395, however there is no "Explorer.exe process" under
HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
all I have are:
1. Default
2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
Please advise.
ThanksPlease see the following mail thread
http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/b6160e7593b8dda0/052524332db36557?lnk=st&q=%22database+engine+tuning+advisor%22&rnum=2&hl=en#052524332db36557
Sidenote:Unfortunately this really is an Appcompat issue and has
nothing to do with DTA, that is, this bug can be reproed using any
process
Manoj
Don wrote:
> we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition
> with SQL
> 05 SP1. try to launch Database Tuning Advisor from the Tools, then got
> the
> following error message box:
> "Microsoft Visual C++ Runtime Library
> Runtime Error
> R6031 - Attempt to initialize the CRT more than once. This indicates a
> bug
> in your application"
> Find out KB 913395, however there is no "Explorer.exe process" under
> HKEY_CURRENT_USER\Software\Microsoft\WindowsNT\CurrentVersion\AppCompatFlags\Layers,
>
> all I have are:
> 1. Default
> 2. D:\en_sql_2005_ent_x64_sp1\en_sql_server_sp1_x64.exe
> Please advise.
> Thanks

No comments:

Post a Comment