Showing posts with label single. Show all posts
Showing posts with label single. Show all posts

Monday, March 26, 2012

Latency Issues

I'm seeing latency issues with a single user on MSDE. It appears that
data doesn't get persisted to the database for up to 30 minutes. What the
devil could be causing this? These are all new machines running the latest
service packs.
TIA
Tina
Hi
The application is not committing the data until very late. In a bad case,
where the connection to the server gets lost, SQL Server will rollback the
transaction as it is not committed. You can loose a lot of data though this.
In effect, there is a BEGIN TRANSACTION and somewhere further down the line,
maybe by chance (due to developer luck), there is a COMMIT TRANSACTION,
resulting in the data being committed.
Ask the developer to look at his application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:uGNS5ZdFFHA.2676@.TK2MSFTNGP12.phx.gbl...
> I'm seeing latency issues with a single user on MSDE. It appears that
> data doesn't get persisted to the database for up to 30 minutes. What
the
> devil could be causing this? These are all new machines running the
latest
> service packs.
> TIA
> Tina
>
sql

Friday, March 9, 2012

Largest Table or Database

Does anyone know what the largest single table or database is? Who owns it?
What's in it?walmart, your shopping habits
"Adrian Walters" <adrian@.na.dhs.org> wrote in message
news:uW42r8KQDHA.1612@.TK2MSFTNGP11.phx.gbl...
> Does anyone know what the largest single table or database is? Who owns
it?
> What's in it?
>|||http://www.stanford.edu/dept/news/pr/02/bigdatabase417.html
Rather smaller, but worth a look is:
http://terraserver.microsoft.com
--
David Portas
--
Please reply only to the newsgroup
--
"Adrian Walters" <adrian@.na.dhs.org> wrote in message
news:uW42r8KQDHA.1612@.TK2MSFTNGP11.phx.gbl...
> Does anyone know what the largest single table or database is? Who owns
it?
> What's in it?
>|||CERN: European Laboratory for Particle Physics,
http://public.web.cern.ch/public/, should have really large db, and it
probably grows faster than anything else.
"Adrian Walters" <adrian@.na.dhs.org> wrote in message
news:uW42r8KQDHA.1612@.TK2MSFTNGP11.phx.gbl...
> Does anyone know what the largest single table or database is? Who owns
it?
> What's in it?
>|||The SQL scalability team built a 10TB Genome database on SQL 2000 to show
that it can be done.
http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp
Brian Goldstein
SQL Product Group
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Quentin Ran" <quentinran@.yahoo.com> wrote in message
news:uP3MrELQDHA.4024@.tk2msftngp13.phx.gbl...
> CERN: European Laboratory for Particle Physics,
> http://public.web.cern.ch/public/, should have really large db, and it
> probably grows faster than anything else.
>
> "Adrian Walters" <adrian@.na.dhs.org> wrote in message
> news:uW42r8KQDHA.1612@.TK2MSFTNGP11.phx.gbl...
> > Does anyone know what the largest single table or database is? Who owns
> it?
> > What's in it?
> >
> >
>