LATCH_EX documentation

Hi,
Is there any documentation on LATCH_EX waittypes. I can't find much on the
subject.
Thanks.http://sqldev.net/misc/WaitTypes.htm
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:%23na11e89DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any documentation on LATCH_EX waittypes. I can't find much on the
> subject.
> Thanks.
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:etgJRu89DHA.1504@.TK2MSFTNGP12.phx.gbl...
> http://sqldev.net/misc/WaitTypes.htm
Thanks, but I've seen that one & that's the only one I could find!|||Well there isn't a whole lot that I know of. What seems to be the problem?
Maybe if you describe it we can help.
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:%23sfW1C99DHA.1116@.TK2MSFTNGP09.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:etgJRu89DHA.1504@.TK2MSFTNGP12.phx.gbl...
> Thanks, but I've seen that one & that's the only one I could find!
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:udLJab99DHA.2532@.TK2MSFTNGP09.phx.gbl...
> Well there isn't a whole lot that I know of. What seems to be the
problem?
> Maybe if you describe it we can help.
We've got some asp based websites that connect to SQL Server Databases.
One of the asp sites was upgraded with a new set of code and now there are a
large number of LATCH_EX waits when we look at current activity in
Enterprise Manager.
The CPU load on the database server is only about 50% but all the websites
that connect to the database server are running slowly.
We have tried increasing the amount of memory available to SQL Server from
1GB to 2GB but that didn't help.
If we stop that website, the LATCH_EX problems go away, however, if we stop
a different website, the problems also go away.
So it's all a little puzzling.|||What about the disk queues on the drive where the log file resides? Check
to ensure they are low and if not you may consider moving the log files to
their own Raid 1 array. How about the tables them selves? Do you have
clustered indexes on most of them? Do you use a lot of text or image
columns?
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:eIdt4U%239DHA.3636@.TK2MSFTNGP10.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:udLJab99DHA.2532@.TK2MSFTNGP09.phx.gbl...
> problem?
> We've got some asp based websites that connect to SQL Server Databases.
> One of the asp sites was upgraded with a new set of code and now there are
a
> large number of LATCH_EX waits when we look at current activity in
> Enterprise Manager.
> The CPU load on the database server is only about 50% but all the websites
> that connect to the database server are running slowly.
> We have tried increasing the amount of memory available to SQL Server from
> 1GB to 2GB but that didn't help.
> If we stop that website, the LATCH_EX problems go away, however, if we
stop
> a different website, the problems also go away.
> So it's all a little puzzling.
>

LATCH_EX documentation

Hi,
Is there any documentation on LATCH_EX waittypes. I can't find much on the
subject.
Thanks.http://sqldev.net/misc/WaitTypes.htm
--
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:%23na11e89DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any documentation on LATCH_EX waittypes. I can't find much on the
> subject.
> Thanks.
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:etgJRu89DHA.1504@.TK2MSFTNGP12.phx.gbl...
> http://sqldev.net/misc/WaitTypes.htm
Thanks, but I've seen that one & that's the only one I could find!|||Well there isn't a whole lot that I know of. What seems to be the problem?
Maybe if you describe it we can help.
--
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:%23sfW1C99DHA.1116@.TK2MSFTNGP09.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:etgJRu89DHA.1504@.TK2MSFTNGP12.phx.gbl...
> > http://sqldev.net/misc/WaitTypes.htm
> Thanks, but I've seen that one & that's the only one I could find!
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:udLJab99DHA.2532@.TK2MSFTNGP09.phx.gbl...
> Well there isn't a whole lot that I know of. What seems to be the
problem?
> Maybe if you describe it we can help.
We've got some asp based websites that connect to SQL Server Databases.
One of the asp sites was upgraded with a new set of code and now there are a
large number of LATCH_EX waits when we look at current activity in
Enterprise Manager.
The CPU load on the database server is only about 50% but all the websites
that connect to the database server are running slowly.
We have tried increasing the amount of memory available to SQL Server from
1GB to 2GB but that didn't help.
If we stop that website, the LATCH_EX problems go away, however, if we stop
a different website, the problems also go away.
So it's all a little puzzling.|||What about the disk queues on the drive where the log file resides? Check
to ensure they are low and if not you may consider moving the log files to
their own Raid 1 array. How about the tables them selves? Do you have
clustered indexes on most of them? Do you use a lot of text or image
columns?
--
Andrew J. Kelly
SQL Server MVP
"Freddy" <noemail@.noemail> wrote in message
news:eIdt4U%239DHA.3636@.TK2MSFTNGP10.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:udLJab99DHA.2532@.TK2MSFTNGP09.phx.gbl...
> > Well there isn't a whole lot that I know of. What seems to be the
> problem?
> > Maybe if you describe it we can help.
> We've got some asp based websites that connect to SQL Server Databases.
> One of the asp sites was upgraded with a new set of code and now there are
a
> large number of LATCH_EX waits when we look at current activity in
> Enterprise Manager.
> The CPU load on the database server is only about 50% but all the websites
> that connect to the database server are running slowly.
> We have tried increasing the amount of memory available to SQL Server from
> 1GB to 2GB but that didn't help.
> If we stop that website, the LATCH_EX problems go away, however, if we
stop
> a different website, the problems also go away.
> So it's all a little puzzling.
>sql

Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)
No it hasn't been released yet and there's no plan to release one in the
near future.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>
sql

Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)No it hasn't been released yet and there's no plan to release one in the
near future.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>

Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)No it hasn't been released yet and there's no plan to release one in the
near future.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>

Largest character data type?

I thought "text" was the largest, as the documentation says the max length
is (2^31)-1
But I can only fit 8000 characters in before it truncates, but even then it
is not exactly 8000 characters, but more like 1000.TEXT is the largest data type. Where do you see the truncation happening'
If it is in Query Analyzer, you need to expand the number of display
character (max is 8192). Your application will never truncate the content of
the TEXT data type.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Wayne M J" <not@.home.nor.bigpuddle.com> wrote in message
news:OSh09QhvDHA.2076@.TK2MSFTNGP09.phx.gbl...
> I thought "text" was the largest, as the documentation says the max length
> is (2^31)-1
> But I can only fit 8000 characters in before it truncates, but even then
it
> is not exactly 8000 characters, but more like 1000.
>|||"SriSamp" <ssampath@.sct.co.in> wrote in message
news:uTxYyohvDHA.2072@.TK2MSFTNGP10.phx.gbl...
> TEXT is the largest data type. Where do you see the truncation happening'
> If it is in Query Analyzer, you need to expand the number of display
> character (max is 8192). Your application will never truncate the content
of
> the TEXT data type.
I see this from the table view, when I 'return all rows' I can scroll
through the field, but it only seems to have stored to a certain point.
The result is visible here:
http://www.wmjackson.cable.nu/website/goto.aspx?id=0|||That must be a limitation with Enterprise Manager. The data will not be
truncated.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Wayne M J" <not@.home.nor.bigpuddle.com> wrote in message
news:eOaaYPjvDHA.1512@.TK2MSFTNGP10.phx.gbl...
> "SriSamp" <ssampath@.sct.co.in> wrote in message
> news:uTxYyohvDHA.2072@.TK2MSFTNGP10.phx.gbl...
> > TEXT is the largest data type. Where do you see the truncation
happening'
> > If it is in Query Analyzer, you need to expand the number of display
> > character (max is 8192). Your application will never truncate the
content
> of
> > the TEXT data type.
> I see this from the table view, when I 'return all rows' I can scroll
> through the field, but it only seems to have stored to a certain point.
> The result is visible here:
> http://www.wmjackson.cable.nu/website/goto.aspx?id=0
>|||"SriSamp" <ssampath@.sct.co.in> wrote in message
news:OEnSpbjvDHA.3256@.TK2MSFTNGP11.phx.gbl...
> That must be a limitation with Enterprise Manager. The data will not be
> truncated.
Actually, that makes sense.