QA database change take too much time

Hi,
MSSQL 2K, SP4 on XP sp2
While connected to local SQL server, when I click on DatabBase drop down
Combo in Query Analyzer, it takes around 10+ seconds before displaying the
databases to select, however if I connect to another SQL server on my office
LAN, then list appears with no time.
appreciate your help to fix this.
Thanks
Falik
To add on to Kalen;
You might be you have enabled the database option "AUTOCLOSE". THis will
close
the MDF and LDF as soon as the last user logs of the database. Again the MDF
and LDF will be opened once a user logins to the database.
How to check this option is checked:-
1. Enterprise manager -- Databases -- Select the database
2. Right click and select properties -- Choose options
3. Chek whether AUTOCLOSE option is "checked". If yes then remove it
This will ensure that MDF and LDF will never closed as soon as last user
logs off.
Thanks
Hari
"Falik Sher" <faliks@.hotmail.com> wrote in message
news:%23npQHWQFHHA.5104@.TK2MSFTNGP03.phx.gbl...
> Hi,
> MSSQL 2K, SP4 on XP sp2
> While connected to local SQL server, when I click on DatabBase drop down
> Combo in Query Analyzer, it takes around 10+ seconds before displaying the
> databases to select, however if I connect to another SQL server on my
> office LAN, then list appears with no time.
> appreciate your help to fix this.
> Thanks
> Falik
>

QA database change take too much time

Hi,
MSSQL 2K, SP4 on XP sp2
While connected to local SQL server, when I click on DatabBase drop down
Combo in Query Analyzer, it takes around 10+ seconds before displaying the
databases to select, however if I connect to another SQL server on my office
LAN, then list appears with no time.
appreciate your help to fix this.
Thanks
FalikAre the databases set to autoclose on your local SQL Server?
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Falik Sher" <faliks@.hotmail.com> wrote in message
news:%23npQHWQFHHA.5104@.TK2MSFTNGP03.phx.gbl...
> Hi,
> MSSQL 2K, SP4 on XP sp2
> While connected to local SQL server, when I click on DatabBase drop down
> Combo in Query Analyzer, it takes around 10+ seconds before displaying the
> databases to select, however if I connect to another SQL server on my
> office LAN, then list appears with no time.
> appreciate your help to fix this.
> Thanks
> Falik
>|||To add on to Kalen;
You might be you have enabled the database option "AUTOCLOSE". THis will
close
the MDF and LDF as soon as the last user logs of the database. Again the MDF
and LDF will be opened once a user logins to the database.
How to check this option is checked:-
1. Enterprise manager -- Databases -- Select the database
2. Right click and select properties -- Choose options
3. Chek whether AUTOCLOSE option is "checked". If yes then remove it
This will ensure that MDF and LDF will never closed as soon as last user
logs off.
Thanks
Hari
"Falik Sher" <faliks@.hotmail.com> wrote in message
news:%23npQHWQFHHA.5104@.TK2MSFTNGP03.phx.gbl...
> Hi,
> MSSQL 2K, SP4 on XP sp2
> While connected to local SQL server, when I click on DatabBase drop down
> Combo in Query Analyzer, it takes around 10+ seconds before displaying the
> databases to select, however if I connect to another SQL server on my
> office LAN, then list appears with no time.
> appreciate your help to fix this.
> Thanks
> Falik
>

QA database change take too much time

Hi,
MSSQL 2K, SP4 on XP sp2
While connected to local SQL server, when I click on DatabBase drop down
Combo in Query Analyzer, it takes around 10+ seconds before displaying the
databases to select, however if I connect to another SQL server on my office
LAN, then list appears with no time.
appreciate your help to fix this.
Thanks
FalikAre the databases set to autoclose on your local SQL Server?
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Falik Sher" <faliks@.hotmail.com> wrote in message
news:%23npQHWQFHHA.5104@.TK2MSFTNGP03.phx.gbl...
> Hi,
> MSSQL 2K, SP4 on XP sp2
> While connected to local SQL server, when I click on DatabBase drop down
> Combo in Query Analyzer, it takes around 10+ seconds before displaying the
> databases to select, however if I connect to another SQL server on my
> office LAN, then list appears with no time.
> appreciate your help to fix this.
> Thanks
> Falik
>|||To add on to Kalen;
You might be you have enabled the database option "AUTOCLOSE". THis will
close
the MDF and LDF as soon as the last user logs of the database. Again the MDF
and LDF will be opened once a user logins to the database.
How to check this option is checked:-
1. Enterprise manager -- Databases -- Select the database
2. Right click and select properties -- Choose options
3. Chek whether AUTOCLOSE option is "checked". If yes then remove it
This will ensure that MDF and LDF will never closed as soon as last user
logs off.
Thanks
Hari
"Falik Sher" <faliks@.hotmail.com> wrote in message
news:%23npQHWQFHHA.5104@.TK2MSFTNGP03.phx.gbl...
> Hi,
> MSSQL 2K, SP4 on XP sp2
> While connected to local SQL server, when I click on DatabBase drop down
> Combo in Query Analyzer, it takes around 10+ seconds before displaying the
> databases to select, however if I connect to another SQL server on my
> office LAN, then list appears with no time.
> appreciate your help to fix this.
> Thanks
> Falik
>

Q: SP4

Hello,
I just installed SQL Server 2000, I noticed that there is SP4, do I need to
install SP3 and then SP4 or I just directly jump to SP4 without installing
SP3.
Thanks,Jim
Service Packs are cumulated , so you don'yt need to intstall SP3
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:E9671444-4D27-465F-9D75-08F5894794E0@.microsoft.com...
> Hello,
> I just installed SQL Server 2000, I noticed that there is SP4, do I need
> to
> install SP3 and then SP4 or I just directly jump to SP4 without installing
> SP3.
> Thanks,
>|||Thanks for the reply. Is this the case for all application of Microsoft? I am
just wondering.
"Uri Dimant" wrote:
> Jim
> Service Packs are cumulated , so you don'yt need to intstall SP3
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:E9671444-4D27-465F-9D75-08F5894794E0@.microsoft.com...
> > Hello,
> >
> > I just installed SQL Server 2000, I noticed that there is SP4, do I need
> > to
> > install SP3 and then SP4 or I just directly jump to SP4 without installing
> > SP3.
> > Thanks,
> >
>
>|||Jim
I think yes , however I was talking about SQL Server.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:49DB4A2A-5BBF-4384-9E9A-C6FF0DB8DF2E@.microsoft.com...
> Thanks for the reply. Is this the case for all application of Microsoft? I
> am
> just wondering.
> "Uri Dimant" wrote:
>> Jim
>> Service Packs are cumulated , so you don'yt need to intstall SP3
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E9671444-4D27-465F-9D75-08F5894794E0@.microsoft.com...
>> > Hello,
>> >
>> > I just installed SQL Server 2000, I noticed that there is SP4, do I
>> > need
>> > to
>> > install SP3 and then SP4 or I just directly jump to SP4 without
>> > installing
>> > SP3.
>> > Thanks,
>> >
>>|||Thanks Uri.
"Uri Dimant" wrote:
> Jim
> I think yes , however I was talking about SQL Server.
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:49DB4A2A-5BBF-4384-9E9A-C6FF0DB8DF2E@.microsoft.com...
> > Thanks for the reply. Is this the case for all application of Microsoft? I
> > am
> > just wondering.
> >
> > "Uri Dimant" wrote:
> >
> >> Jim
> >> Service Packs are cumulated , so you don'yt need to intstall SP3
> >>
> >>
> >>
> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> news:E9671444-4D27-465F-9D75-08F5894794E0@.microsoft.com...
> >> > Hello,
> >> >
> >> > I just installed SQL Server 2000, I noticed that there is SP4, do I
> >> > need
> >> > to
> >> > install SP3 and then SP4 or I just directly jump to SP4 without
> >> > installing
> >> > SP3.
> >> > Thanks,
> >> >
> >>
> >>
> >>
>
>|||JIM.H. wrote:
> Thanks Uri.
> "Uri Dimant" wrote:
>> Jim
>> I think yes , however I was talking about SQL Server.
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:49DB4A2A-5BBF-4384-9E9A-C6FF0DB8DF2E@.microsoft.com...
>> Thanks for the reply. Is this the case for all application of Microsoft? I
>> am
>> just wondering.
>> "Uri Dimant" wrote:
>> Jim
>> Service Packs are cumulated , so you don'yt need to intstall SP3
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:E9671444-4D27-465F-9D75-08F5894794E0@.microsoft.com...
>> Hello,
>> I just installed SQL Server 2000, I noticed that there is SP4, do I
>> need
>> to
>> install SP3 and then SP4 or I just directly jump to SP4 without
>> installing
>> SP3.
>> Thanks,
>>
>>
If you took the time to read a few lines about SP4 on
http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
, you'd see -
"SP4 is a cumulative Service Pack containing all of the fixes from
previous service packs, including MS03-031 security bulletin."
It would have taken you less time than going to this newsgroup and post
the question.
Regards
Steen