Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas

"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SHOWCONTIG always use table S-lock?

I noticed that while running a DBCC SHOWCONTIG - this processed blocked
another process attempting to acquire an IX lock on that table. I saw that
the showcontig had an "S" lock on the table.
Is there any way to influence SQL Server into taking an IS lock on the table
and S locks on the pages?
Thanks in advance
WITH FAST Option may help.
also if a table is a heap (No Clustered Index) that will impact this
behavior. You WANT each table to have a clustered index (in General)
Cheers
Greg Jackson
PDX, OR
|||Not currently. Even using WITH FAST requires a Shared Table lock (however,
except on the largest tables any blocking should be fairly transient as the
results are returned so quickly)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> I noticed that while running a DBCC SHOWCONTIG - this processed blocked
> another process attempting to acquire an IX lock on that table. I saw
that
> the showcontig had an "S" lock on the table.
> Is there any way to influence SQL Server into taking an IS lock on the
table
> and S locks on the pages?
> Thanks in advance
>
|||Not true. If you only specify WITH FAST for a clustered or non-clustered
index it will acquire an IS table lock - that's the entire reason for me
adding the option in SQL Server 2000.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
> Not currently. Even using WITH FAST requires a Shared Table lock (however,
> except on the largest tables any blocking should be fairly transient as
the
> results are returned so quickly)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> that
> table
>
|||That's what I thought (and I can see now that it is) however when I was
testing before posting my original answer ( I really did test!) I was using
dbcc showcontig('wildtest') with fast
where wildtest has a clustered index and it was getting blocked by an IX
table lock from a transaction I left open so I could examine the locking. I
just tried it again specifying the clustered index explicitly and no
blocking
dbcc showcontig('wildtest',1) with fast
This is what threw me off track :-)
I was under the impression that the first query on a table with a clustered
index would result in the same behaviour as the second one ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:%231ITfVbSEHA.3812@.TK2MSFTNGP11.phx.gbl...
> Not true. If you only specify WITH FAST for a clustered or non-clustered
> index it will acquire an IS table lock - that's the entire reason for me
> adding the option in SQL Server 2000.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
(however,[vbcol=seagreen]
> the
blocked[vbcol=seagreen]

>

Does SHOWCONTIG always use table S-lock?

I noticed that while running a DBCC SHOWCONTIG - this processed blocked
another process attempting to acquire an IX lock on that table. I saw that
the showcontig had an "S" lock on the table.
Is there any way to influence SQL Server into taking an IS lock on the table
and S locks on the pages?
Thanks in advanceWITH FAST Option may help.
also if a table is a heap (No Clustered Index) that will impact this
behavior. You WANT each table to have a clustered index (in General)
Cheers
Greg Jackson
PDX, OR|||Not currently. Even using WITH FAST requires a Shared Table lock (however,
except on the largest tables any blocking should be fairly transient as the
results are returned so quickly)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> I noticed that while running a DBCC SHOWCONTIG - this processed blocked
> another process attempting to acquire an IX lock on that table. I saw
that
> the showcontig had an "S" lock on the table.
> Is there any way to influence SQL Server into taking an IS lock on the
table
> and S locks on the pages?
> Thanks in advance
>|||Not true. If you only specify WITH FAST for a clustered or non-clustered
index it will acquire an IS table lock - that's the entire reason for me
adding the option in SQL Server 2000.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
> Not currently. Even using WITH FAST requires a Shared Table lock (however,
> except on the largest tables any blocking should be fairly transient as
the
> results are returned so quickly)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> that
> table
>|||That's what I thought (and I can see now that it is) however when I was
testing before posting my original answer ( I really did test!) I was using
dbcc showcontig('wildtest') with fast
where wildtest has a clustered index and it was getting blocked by an IX
table lock from a transaction I left open so I could examine the locking. I
just tried it again specifying the clustered index explicitly and no
blocking
dbcc showcontig('wildtest',1) with fast
This is what threw me off track :-)
I was under the impression that the first query on a table with a clustered
index would result in the same behaviour as the second one ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:%231ITfVbSEHA.3812@.TK2MSFTNGP11.phx.gbl...
> Not true. If you only specify WITH FAST for a clustered or non-clustered
> index it will acquire an IS table lock - that's the entire reason for me
> adding the option in SQL Server 2000.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
(however,[vbcol=seagreen]
> the
blocked[vbcol=seagreen]
[vbcol=seagreen]
>

Does SHOWCONTIG always use table S-lock?

I noticed that while running a DBCC SHOWCONTIG - this processed blocked
another process attempting to acquire an IX lock on that table. I saw that
the showcontig had an "S" lock on the table.
Is there any way to influence SQL Server into taking an IS lock on the table
and S locks on the pages?
Thanks in advanceWITH FAST Option may help.
also if a table is a heap (No Clustered Index) that will impact this
behavior. You WANT each table to have a clustered index (in General)
Cheers
Greg Jackson
PDX, OR|||Not currently. Even using WITH FAST requires a Shared Table lock (however,
except on the largest tables any blocking should be fairly transient as the
results are returned so quickly)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> I noticed that while running a DBCC SHOWCONTIG - this processed blocked
> another process attempting to acquire an IX lock on that table. I saw
that
> the showcontig had an "S" lock on the table.
> Is there any way to influence SQL Server into taking an IS lock on the
table
> and S locks on the pages?
> Thanks in advance
>|||Not true. If you only specify WITH FAST for a clustered or non-clustered
index it will acquire an IS table lock - that's the entire reason for me
adding the option in SQL Server 2000.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
> Not currently. Even using WITH FAST requires a Shared Table lock (however,
> except on the largest tables any blocking should be fairly transient as
the
> results are returned so quickly)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> > I noticed that while running a DBCC SHOWCONTIG - this processed blocked
> > another process attempting to acquire an IX lock on that table. I saw
> that
> > the showcontig had an "S" lock on the table.
> >
> > Is there any way to influence SQL Server into taking an IS lock on the
> table
> > and S locks on the pages?
> >
> > Thanks in advance
> >
> >
>|||That's what I thought (and I can see now that it is) however when I was
testing before posting my original answer ( I really did test!) I was using
dbcc showcontig('wildtest') with fast
where wildtest has a clustered index and it was getting blocked by an IX
table lock from a transaction I left open so I could examine the locking. I
just tried it again specifying the clustered index explicitly and no
blocking
dbcc showcontig('wildtest',1) with fast
This is what threw me off track :-)
I was under the impression that the first query on a table with a clustered
index would result in the same behaviour as the second one ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:%231ITfVbSEHA.3812@.TK2MSFTNGP11.phx.gbl...
> Not true. If you only specify WITH FAST for a clustered or non-clustered
> index it will acquire an IS table lock - that's the entire reason for me
> adding the option in SQL Server 2000.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:uJCeJ7aSEHA.3728@.TK2MSFTNGP11.phx.gbl...
> > Not currently. Even using WITH FAST requires a Shared Table lock
(however,
> > except on the largest tables any blocking should be fairly transient as
> the
> > results are returned so quickly)
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> >
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> > news:%23%23LyYoZSEHA.3636@.TK2MSFTNGP09.phx.gbl...
> > > I noticed that while running a DBCC SHOWCONTIG - this processed
blocked
> > > another process attempting to acquire an IX lock on that table. I saw
> > that
> > > the showcontig had an "S" lock on the table.
> > >
> > > Is there any way to influence SQL Server into taking an IS lock on the
> > table
> > > and S locks on the pages?
> > >
> > > Thanks in advance
> > >
> > >
> >
> >
>sql

Does rolling a cluster create down time?

We have about 40 DB's blackening 40 web sites running on a single
SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the
next I'm wondering exactly what sort of outage our clients would see. Since
the entire cluster rolls in under a minute would there just be a delay on
the web sites with data requests in response from the web/ODBC side or would
there be an ODBC failure. Also, with regards to active web sessions, would
clients mid transaction on the web pages need to restart their transaction
or would there be a short wait during the SQL roll and then they could
proceed with the transaction (or would they need to start all over again).
I guess I'm wondering if I need to add the 1 minute of roll time into our
annual downtime calculation if the clients see an application
failure/unavailability.
On the roll all client connections are lost and must be restarted. As for
what exactly happens, well that depends on the application. If the rows are
returned locally or if they are stored on the web server. And at what stage
in the process each client was in.
Bottom line, in most cases they either hit F5 (refresh) or never notice.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||What the clients see or how it affects their transactions depends solely on
how the client app was written. It must be cluster aware. By that I mean
it must be able to detect a connection failure and reconnect. It must also
be able to resubmit the current transaction as it will be rolled back on the
server side when the cluster comes back up.
Andrew J. Kelly SQL MVP
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||A cluster host transition is exactly like a SQL server stop-start. All
transactions are rolled forward or back at startup. The server is down
during the transition. The client application will see a connection timeout
or a query timeout or a broken connection. Whether the application traps
that or displays that to the end-user depends on the skill of the programmer
who wrote it.
Short answer, a cluster transition is downtime.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||During the failover process, any active connections are broken. For Web browser users, a simple refresh of the Web page should create a new database connection. In a more traditional client/server application, or
one that relies heavily on a middle tier, application designers may want to consider checking to see whether the connection exists, and if not, reconnect. Therefore, whatever the user was working on when the server
went down may not be completed, unless the transaction completes before the server goes down or the transaction is handled within the application.
For more information, see the Knowledge Base article "Q273673 - Virtual Server Client Connections Must be Controlled by Clients" at:
http://support.microsoft.com/?kbid=273673
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Does MS Access installation is required for running application that uses Access mdb file

Hi,

I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?

Thanks,

Rao

No, they don't need Access. They will simply need to have MDAC installed, and chances are it will already be there. If not get it here

http://msdn.microsoft.com/data/ref/mdac/

|||

The Information is helpful.

Thanks

Does Disk space affect Database performance

We have aroud 12 databases running on a live production server which is
segmented
into 3 physical drives.
The E drive is where data and logs are stored.
We have implemented a back up strategy over the past week. As a result , the
E
drive has shrunk in size.
Its a total of 135 GB but has 125 MB free.
Consequently we have noticed that various VB6 and MS Access applications are
suffering from slow performance.
But..the apps are merely querying data and bringing it back to the client.
My question is the lack of disk space affecting performance?
The lack of disk space will cause performance problems, iirc the MS
recommendation is to not exceed about 80% capacity on a disk/disk set.
Not sure what you mean by backing up causing the disk to shrink in
size? Also not a good idea to have log and data files on the same
physical drive.
ALI

Does Disk space affect Database performance

We have aroud 12 databases running on a live production server which is
segmented
into 3 physical drives.
The E drive is where data and logs are stored.
We have implemented a back up strategy over the past week. As a result , the
E
drive has shrunk in size.
Its a total of 135 GB but has 125 MB free.
Consequently we have noticed that various VB6 and MS Access applications are
suffering from slow performance.
But..the apps are merely querying data and bringing it back to the client.
My question is the lack of disk space affecting performance?The lack of disk space will cause performance problems, iirc the MS
recommendation is to not exceed about 80% capacity on a disk/disk set.
Not sure what you mean by backing up causing the disk to shrink in
size? Also not a good idea to have log and data files on the same
physical drive.
ALI

Does Disk space affect Database performance

We have aroud 12 databases running on a live production server which is
segmented
into 3 physical drives.
The E drive is where data and logs are stored.
We have implemented a back up strategy over the past week. As a result , the
E
drive has shrunk in size.
Its a total of 135 GB but has 125 MB free.
Consequently we have noticed that various VB6 and MS Access applications are
suffering from slow performance.
But..the apps are merely querying data and bringing it back to the client.
My question is the lack of disk space affecting performance?The lack of disk space will cause performance problems, iirc the MS
recommendation is to not exceed about 80% capacity on a disk/disk set.
Not sure what you mean by backing up causing the disk to shrink in
size? Also not a good idea to have log and data files on the same
physical drive.
ALI

does database backup truncate tlog ?

I am running sql server 2000 sp3a on win2k. does complete database backup do
tlog backup and truncate it also ?Jay
No,it does not
This is a great thing in SQL Server that you can have a full backup that
was done let me say at 1 May and at 1 June and doing t-log file backup. In
case of disaster you restore a full backup (at 1 May ) and apply all t-log
file backups till a point of distaster .
If sql server was trunucated a log file during the backup you was not be
able to restore all log files due to breaking chaines of transactions
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:A4A8062F-6DA1-4AA8-B33B-63F91E3E9737@.microsoft.com...
>I am running sql server 2000 sp3a on win2k. does complete database backup
>do
> tlog backup and truncate it also ?
>|||does complete database backup do
> tlog backup and truncate it also ?
No when your db is in bulk_logged or full recovery model. In order to
truncate the log, you should backup the transaction log, using "backup log".
The db should be set to use bulk_logged or full recovery model in order to
backup the transaction log.
If your database's recovery model is simple, you can not backup the
transaction log. SQL Server will truncate the transaction log after a
checkpoint.
AMB
"Jay" wrote:
> I am running sql server 2000 sp3a on win2k. does complete database backup do
> tlog backup and truncate it also ?
>|||Correction,
> No when your db is in bulk_logged or full recovery model.
No, a full backup of the db does not truncate the log, no matter what
recovery model is it using.
AMB
"Alejandro Mesa" wrote:
> does complete database backup do
> > tlog backup and truncate it also ?
> No when your db is in bulk_logged or full recovery model. In order to
> truncate the log, you should backup the transaction log, using "backup log".
> The db should be set to use bulk_logged or full recovery model in order to
> backup the transaction log.
> If your database's recovery model is simple, you can not backup the
> transaction log. SQL Server will truncate the transaction log after a
> checkpoint.
>
> AMB
> "Jay" wrote:
> > I am running sql server 2000 sp3a on win2k. does complete database backup do
> > tlog backup and truncate it also ?
> >

does database backup truncate tlog ?

I am running sql server 2000 sp3a on win2k. does complete database backup do
tlog backup and truncate it also ?
Jay
No,it does not
This is a great thing in SQL Server that you can have a full backup that
was done let me say at 1 May and at 1 June and doing t-log file backup. In
case of disaster you restore a full backup (at 1 May ) and apply all t-log
file backups till a point of distaster .
If sql server was trunucated a log file during the backup you was not be
able to restore all log files due to breaking chaines of transactions
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:A4A8062F-6DA1-4AA8-B33B-63F91E3E9737@.microsoft.com...
>I am running sql server 2000 sp3a on win2k. does complete database backup
>do
> tlog backup and truncate it also ?
>
|||does complete database backup do
> tlog backup and truncate it also ?
No when your db is in bulk_logged or full recovery model. In order to
truncate the log, you should backup the transaction log, using "backup log".
The db should be set to use bulk_logged or full recovery model in order to
backup the transaction log.
If your database's recovery model is simple, you can not backup the
transaction log. SQL Server will truncate the transaction log after a
checkpoint.
AMB
"Jay" wrote:

> I am running sql server 2000 sp3a on win2k. does complete database backup do
> tlog backup and truncate it also ?
>
|||Correction,

> No when your db is in bulk_logged or full recovery model.
No, a full backup of the db does not truncate the log, no matter what
recovery model is it using.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> does complete database backup do
> No when your db is in bulk_logged or full recovery model. In order to
> truncate the log, you should backup the transaction log, using "backup log".
> The db should be set to use bulk_logged or full recovery model in order to
> backup the transaction log.
> If your database's recovery model is simple, you can not backup the
> transaction log. SQL Server will truncate the transaction log after a
> checkpoint.
>
> AMB
> "Jay" wrote:

does database backup truncate tlog ?

I am running sql server 2000 sp3a on win2k. does complete database backup do
tlog backup and truncate it also ?Jay
No,it does not
This is a great thing in SQL Server that you can have a full backup that
was done let me say at 1 May and at 1 June and doing t-log file backup. In
case of disaster you restore a full backup (at 1 May ) and apply all t-log
file backups till a point of distaster .
If sql server was trunucated a log file during the backup you was not be
able to restore all log files due to breaking chaines of transactions
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:A4A8062F-6DA1-4AA8-B33B-63F91E3E9737@.microsoft.com...
>I am running sql server 2000 sp3a on win2k. does complete database backup
>do
> tlog backup and truncate it also ?
>|||does complete database backup do
> tlog backup and truncate it also ?
No when your db is in bulk_logged or full recovery model. In order to
truncate the log, you should backup the transaction log, using "backup log".
The db should be set to use bulk_logged or full recovery model in order to
backup the transaction log.
If your database's recovery model is simple, you can not backup the
transaction log. SQL Server will truncate the transaction log after a
checkpoint.
AMB
"Jay" wrote:

> I am running sql server 2000 sp3a on win2k. does complete database backup
do
> tlog backup and truncate it also ?
>|||Correction,

> No when your db is in bulk_logged or full recovery model.
No, a full backup of the db does not truncate the log, no matter what
recovery model is it using.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> does complete database backup do
> No when your db is in bulk_logged or full recovery model. In order to
> truncate the log, you should backup the transaction log, using "backup log
".
> The db should be set to use bulk_logged or full recovery model in order to
> backup the transaction log.
> If your database's recovery model is simple, you can not backup the
> transaction log. SQL Server will truncate the transaction log after a
> checkpoint.
>
> AMB
> "Jay" wrote:
>

Does anyone know what this means? Anyone?

AuthzInitializeContextFromSid: Win32 error: 234
get this when trying to send an email subscription or a file-share
subscription. Running the service as a domain account and made the account a
member of the WAA group.I should probably mention that I love the "there is more information in the
log file" message that you can find....you guessed it...in the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.|||In fact, I read the log file, it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
I eventually got out of this endless loop after about 16 hours of
recursively checking the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.

does anyone know the answer?

i have two Running Total Fields
Total NWN and Total Keyed
how can i add these two Running Total Fields?
and how can i connect mysql to crystal report?
thanks1) Just add them in a formula
{#Total NWN} + {#Total Keyed}

2) Don't know|||i have two Running Total Fields
Total NWN and Total Keyed

how can i add these two Running Total Fields?
At the end of outer group which calculates total of these fields,
add like this: {Total Keyed} + {Total NWN}.
Please try since i didn't test this syntax.

and how can i connect mysql to crystal report?

thanks
Did you read the answer in your previous started thread? ("http://www.dev-archive.com/forum/showthread.php?t=437244) :mad:

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.
Steve,
You may find an explanation of this at:
http://support.microsoft.com/default...b;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>
|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default...b;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.
>
|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the[vbcol=seagreen]
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg
> statement.
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> >
> > sql2k, nt5.
> > I have a stored procedure drop and re-create webtask... this is the msg
> i've
> > got when running it.
> >
> > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
statement.
> > [SQLSTATE 42000]
> >
> > does anyone know what it's about? thank you.
> >
> >
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> > Steve,
> >
> > You may find an explanation of this at:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> >
> > Hope it helps,
> > Russell Fields
> >
> > "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> > news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> > >
> > > sql2k, nt5.
> > > I have a stored procedure drop and re-create webtask... this is the
msg
> > i've
> > > got when running it.
> > >
> > > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
> statement.
> > > [SQLSTATE 42000]
> > >
> > > does anyone know what it's about? thank you.
> > >
> > >
> >
> >
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/defaul...kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/defaul...kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.[vbcol=seagreen]
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg[vbcol=seagreen]
> statement.
>

Does anyone have sql2005 EE running on 64 bit Itanium server?

I don't think mine is using all of the memory it could on the server. I've read that the Task Manager does not give you an accurate measure of the memory usage but 130 MB max does not seem right on a 12 GB server. I've set the minimum to 2 GB in SSMS. The account that is running sqlservice has Lock Pages in Memory privileges. I've turned on AWE in SSMS just to be safe. We are experiencing high CPU usage and my theory is that it is caused my unnecessary I/O due to not being able to cache. The serve has Windows 2003 sp1. The SQL2005 Buffer Manager AWE Lookup maps\sec, stolen maps\sec, unmap calls/sec, unmap pages/sec, write maps/sec are all 0.

Any help would be appreciated. Below is the out from DBCC MEMORYSTATUS. This server also has an instance of sql2000 EE on it with max memory set to 5 GB and it seems to be running fine.

Memory Manager KB

--

VM Reserved 12687344

VM Committed 87304

AWE Allocated 3211008

Reserved Memory 1024

Reserved Memory In Use 0

(5 row(s) affected)

Memory node Id = 0 KB

--

VM Reserved 12681712

VM Committed 81752

AWE Allocated 3211008

MultiPage Allocator 19864

SinglePage Allocator 272960

(5 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 4240

MultiPage Allocator 4984

(7 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total) KB

- --

VM Reserved 12615680

VM Committed 16384

AWE Allocated 3211008

SM Reserved 0

SM Commited 0

SinglePage Allocator 0

MultiPage Allocator 1128

(7 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 88

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 672

MultiPage Allocator 96

(7 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total) KB

- --

VM Reserved 240

VM Committed 240

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 320

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total) KB

- --

VM Reserved 3904

VM Committed 3904

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1280

MultiPage Allocator 472

(7 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 728

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLCLR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 112

MultiPage Allocator 320

(7 row(s) affected)

MEMORYCLERK_SQLHTTP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SNI (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 72

MultiPage Allocator 16

(7 row(s) affected)

MEMORYCLERK_FULLTEXT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLXP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_BHF (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 56

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLQERESERVATIONS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 331616

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_HOST (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SOSNODE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 3416

MultiPage Allocator 11360

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 48

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_OBJCP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 69400

MultiPage Allocator 672

(7 row(s) affected)

CACHESTORE_SQLCP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 166824

MultiPage Allocator 32

(7 row(s) affected)

CACHESTORE_PHDR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 17944

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XPROC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 144

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_TEMPTABLES (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 32

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_NOTIF (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_VIEWDEFINITIONS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBTYPE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBELEMENT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBATTRIBUTE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_STACKFRAMES (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 0

MultiPage Allocator 8

(7 row(s) affected)

CACHESTORE_BROKERTBLACS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 456

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERKEK (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERDSH (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERUSERCERTLOOKUP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERRSB (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERREADONLY (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 96

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERTO (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_EVENTS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_SYSTEMROWSET (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1784

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_SCHEMAMGR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 2192

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_DBMETADATA (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 2800

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_TOKENPERM (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 872

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_OBJPERM (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 256

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_SXC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 168

MultiPage Allocator 0

(7 row(s) affected)

OBJECTSTORE_LBSS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 32

MultiPage Allocator 544

(7 row(s) affected)

OBJECTSTORE_SNI_PACKET (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1824

MultiPage Allocator 48

(7 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 288

MultiPage Allocator 0

(7 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (Total) KB

- --

VM Reserved 8192

VM Committed 8192

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 20856

MultiPage Allocator 0

(7 row(s) affected)

Buffer Distribution Buffers

--

Stolen 13626

Free 28271

Cached 33153

Database (clean) 315604

Database (dirty) 2557

I/O 0

Latched 5

(7 row(s) affected)

Buffer Counts Buffers

--

Committed 393216

Target 393216

Hashed 318166

Stolen Potential 297983

External Reservation 28759

Min Free 64

Visible 393216

Available Paging File 2528231

(8 row(s) affected)

Procedure Cache Value

--

TotalProcs 2358

TotalPages 31877

InUsePages 425

(3 row(s) affected)

Global Memory Objects Buffers

--

Resource 257

Locks 2610

XDES 42

SETLS 2

SE Dataset Allocators 4

SubpDesc Allocators 2

SE SchemaManager 273

SQLCache 505

Replication 2

ServerGlobal 48

XP Global 2

SortTables 2

(12 row(s) affected)

Query Memory Objects Value

--

Grants 1

Waiting 0

Available (Buffers) 241218

Maximum (Buffers) 282670

Limit 282670

Next Request 0

Waiting For 0

Cost 0

Timeout 0

Wait Time 0

Last Target 295470

(11 row(s) affected)

Small Query Memory Objects Value

--

Grants 0

Waiting 0

Available (Buffers) 12800

Maximum (Buffers) 12800

Limit 12800

(5 row(s) affected)

Optimization Queue Value

--

Overall Memory 2581880832

Target Memory 2209619968

Last Notification 1

Timeout 6

Early Termination Factor 5

(5 row(s) affected)

Small Gateway Value

--

Configured Units 8

Available Units 8

Acquires 0

Waiters 0

Threshold Factor 500000

Threshold 500000

(6 row(s) affected)

Medium Gateway Value

--

Configured Units 2

Available Units 2

Acquires 0

Waiters 0

Threshold Factor 12

(5 row(s) affected)

Big Gateway Value

--

Configured Units 1

Available Units 1

Acquires 0

Waiters 0

Threshold Factor 8

(5 row(s) affected)

MEMORYBROKER_FOR_CACHE Value

-- --

Allocations 33157

Rate 2

Target Allocations 301911

Future Allocations 0

Last Notification 1

(5 row(s) affected)

MEMORYBROKER_FOR_STEAL Value

-- --

Allocations 963

Rate 14

Target Allocations 269729

Future Allocations 0

Last Notification 1

(5 row(s) affected)

MEMORYBROKER_FOR_RESERVE Value

-- --

Allocations 41452

Rate 21351

Target Allocations 315171

Future Allocations 70667

Last Notification 1

(5 row(s) affected)

What "edition" of 2003 is installed. You need to have Enterprise or Data Center installed for 12gb of RAM. See http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx.

Did you set PAE in the Windows boot.ini? If you right click on "My Computer" and select "Properties", how much memory does it show and does it say "Physical Address Extension" after the RAM?

2005 only allocates memory when needed, instead of 2000 which just grabs it all when the service starts.|||

win 2003 EE sp1.

The server doesn't seem to have a boot.ini file. Does 64 bit itanium servers usually have one?

The my computer reading is 11.9 GB of Ram. It does not say "Physical Address Extendsions"

The sql2000 instance is using 6 GB of ram so AWE should be working but it isn't for sql2005.

We use a lot of table variable in 2005 that are stored in memory if it is available an I think sql is thinking there isn't any and writing them to the tempdb instead.

Thanks for responding to my post

|||I forgot in 64bit you don't set PAE, that is only a 32 bit problem.

In SQL 2005 tempdb usage was completely changed. It now stores a lot of temp data that 2000 had in RAM, in tempdb.

See: http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx|||I read that one yesterday. "System" has locked pages in memory rights. Our instance is running under "Local System" so it should be doing this, right.|||I talked to someone at Microsoft and they said to ignore Task Manager reading (nice). You can tell SQL memory usage by using Performance Monitor object SQL Memory Management counters "Target Server Memory" and "Total Server Memory". So, unless you are a DBA and know about this Task Manager misleads you.