473,320 Members | 2,202 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

App hangs when SQL table open

Jon
Hello all,

We have a strange problem with our app. If the database table to which the
app is writing is open, the app hangs and just takes ages.

Why would this be so?

Thanks,

Jon
Aug 4 '06 #1
16 1212
Because your connection is waiting for the lock on the table to go away.

Jon wrote:
Hello all,

We have a strange problem with our app. If the database table to which the
app is writing is open, the app hangs and just takes ages.

Why would this be so?

Thanks,

Jon
Aug 4 '06 #2
Jon
Ray,

Thanks for the response. Can you help with how to overcome it?

Jon

"Ray Booysen" wrote:
Because your connection is waiting for the lock on the table to go away.

Jon wrote:
Hello all,

We have a strange problem with our app. If the database table to which the
app is writing is open, the app hangs and just takes ages.

Why would this be so?

Thanks,

Jon
Aug 4 '06 #3
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:F5**********************************@microsof t.com...
Thanks for the response. Can you help with how to overcome it?
Something somewhere is opening a table lock which is not being closed.

How are you interfacing with ADO.NET?

What other systems might be causing the problem? E.g. is your DBA opening
the table in design mode through Enterprise Manager...?
Aug 4 '06 #4
Jon
Hi Mark.

Yep, were interfacing with ADO.net using the MS Data Application Blocks.

Nope, no other Enterprise manager windows are open. But this is the problem,
we need to report on the system via EM, but soon as we do that, the app hangs
- which is how we found the problem.

It's a logging database with is causing the problems. The funny thing is, if
we open any table in the main database (where all other data is saved, users
etc) we can still use the app with no hangs.

Any help would be great.

Thanks,

Jon

"Mark Rae" wrote:
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:F5**********************************@microsof t.com...
Thanks for the response. Can you help with how to overcome it?

Something somewhere is opening a table lock which is not being closed.

How are you interfacing with ADO.NET?

What other systems might be causing the problem? E.g. is your DBA opening
the table in design mode through Enterprise Manager...?
Aug 4 '06 #5
Jon
Hell all again.

I think I've managed to identify what the problem is. Having cleared out all
30,000 rows, the app now does NOT hand when the table is open. Therefore, I
beleve it to be down to the volume of data.

Based on this, what can be done to speed things up? Indexs?

Thanks,

Jon

"Jon" wrote:
Hello all,

We have a strange problem with our app. If the database table to which the
app is writing is open, the app hangs and just takes ages.

Why would this be so?

Thanks,

Jon
Aug 4 '06 #6
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:C6**********************************@microsof t.com...
Hell all again.
It can't be that bad surely... ;-)
I think I've managed to identify what the problem is. Having cleared out
all
30,000 rows, the app now does NOT hand when the table is open. Therefore,
I
beleve it to be down to the volume of data.

Based on this, what can be done to speed things up? Indexs?
I think you maybe need to take a step back and examine your design. 30,000
rows is nothing to SQL Server...

HOWEVER, what are you *actually* doing with Enterprise Manager? You're
surely not trying to open the table AND bring all 30,000 rows into the local
machine's memory...? If anything's going to shag your performance, that
will...!
Aug 4 '06 #7
Jon
lol, well spotted Mark - no, thankfully things aren't that bad.

Yes, we are doing exactly that. Using EM to perform queries to get an idea
of what is in the log table. However, when we do this, the app just dies.

How else could we report on the table?

Thanks.

Jon

"Mark Rae" wrote:
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:C6**********************************@microsof t.com...
Hell all again.

It can't be that bad surely... ;-)
I think I've managed to identify what the problem is. Having cleared out
all
30,000 rows, the app now does NOT hand when the table is open. Therefore,
I
beleve it to be down to the volume of data.

Based on this, what can be done to speed things up? Indexs?

I think you maybe need to take a step back and examine your design. 30,000
rows is nothing to SQL Server...

HOWEVER, what are you *actually* doing with Enterprise Manager? You're
surely not trying to open the table AND bring all 30,000 rows into the local
machine's memory...? If anything's going to shag your performance, that
will...!
Aug 4 '06 #8
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:62**********************************@microsof t.com...
Yes, we are doing exactly that. Using EM to perform queries to get an idea
of what is in the log table. However, when we do this, the app just dies.
Blimey! Just when you think you've heard it all...
How else could we report on the table?
Just about any way you can think of which doesn't actually involve opening
the table and reading its entire contents row by row!

Pop a query window, write a stored procedure, pretty much anything but what
you're doing...

What do you *actually* need to know?
Aug 4 '06 #9
Jon
Hi Mark.

So purely by having the table open in EM, will cause ASP.net (our app) on
our web server to hang / perform very slowly?

We're reporting on pages vited, by whom, times etc.

Thanks for your help so far, really appreciate it!

Jon

"Mark Rae" wrote:
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:62**********************************@microsof t.com...
Yes, we are doing exactly that. Using EM to perform queries to get an idea
of what is in the log table. However, when we do this, the app just dies.

Blimey! Just when you think you've heard it all...
How else could we report on the table?

Just about any way you can think of which doesn't actually involve opening
the table and reading its entire contents row by row!

Pop a query window, write a stored procedure, pretty much anything but what
you're doing...

What do you *actually* need to know?
Aug 4 '06 #10
Why use EM?? It keeps the actual table open on the queries. Use the
Query Analyzer which pulls the data locally.

Jon wrote:
Hi Mark.

So purely by having the table open in EM, will cause ASP.net (our app) on
our web server to hang / perform very slowly?

We're reporting on pages vited, by whom, times etc.

Thanks for your help so far, really appreciate it!

Jon

"Mark Rae" wrote:
>"Jon" <Jo*@discussions.microsoft.comwrote in message
news:62**********************************@microso ft.com...
>>Yes, we are doing exactly that. Using EM to perform queries to get an idea
of what is in the log table. However, when we do this, the app just dies.
Blimey! Just when you think you've heard it all...
>>How else could we report on the table?
Just about any way you can think of which doesn't actually involve opening
the table and reading its entire contents row by row!

Pop a query window, write a stored procedure, pretty much anything but what
you're doing...

What do you *actually* need to know?
Aug 4 '06 #11
As far as I know, using EM opens a read/write lock which means that no
other queries can use that data you've pulled which will give you the
symptoms you're seeing.

Jon wrote:
Hi Mark.

So purely by having the table open in EM, will cause ASP.net (our app) on
our web server to hang / perform very slowly?

We're reporting on pages vited, by whom, times etc.

Thanks for your help so far, really appreciate it!

Jon

"Mark Rae" wrote:
>"Jon" <Jo*@discussions.microsoft.comwrote in message
news:62**********************************@microso ft.com...
>>Yes, we are doing exactly that. Using EM to perform queries to get an idea
of what is in the log table. However, when we do this, the app just dies.
Blimey! Just when you think you've heard it all...
>>How else could we report on the table?
Just about any way you can think of which doesn't actually involve opening
the table and reading its entire contents row by row!

Pop a query window, write a stored procedure, pretty much anything but what
you're doing...

What do you *actually* need to know?
Aug 4 '06 #12
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:9E**********************************@microsof t.com...
So purely by having the table open in EM, will cause ASP.net (our app) on
our web server to hang / perform very slowly?
It will set an exclusive lock on your table - UNDER NO CIRCUMSTANCES use EM
to open a table on a production server!!!!!
We're reporting on pages vited, by whom, times etc.
So why on earth are you using Enterprise Manager for this???
Aug 4 '06 #13
"Ray Booysen" <rj***********@rjb.za.netwrote in message
news:eF**************@TK2MSFTNGP04.phx.gbl...
As far as I know, using EM opens a read/write lock which means that no
other queries can use that data you've pulled which will give you the
symptoms you're seeing.
Correct. EM should NEVER EVER be used to open a table on a production
server.
Aug 4 '06 #14

"Ray Booysen" <rj***********@rjb.za.netwrote in message
news:uk**************@TK2MSFTNGP04.phx.gbl...
Why use EM??
Inexperience, I guess...?
>It keeps the actual table open on the queries.
Correct.
>Use the Query Analyzer which pulls the data locally.
Yep, or anything else which doesn't lock the table!
Aug 4 '06 #15
Jon
Mark,

You've been a great help, thank you very much. I can go back to the business
with this and that they must use Query Analyser.

We've using EM as a temp measure until our BO universe is set up - not ideal
but has served it's purpose.

Thanks again for all your help.

Jon

"Mark Rae" wrote:
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:9E**********************************@microsof t.com...
So purely by having the table open in EM, will cause ASP.net (our app) on
our web server to hang / perform very slowly?

It will set an exclusive lock on your table - UNDER NO CIRCUMSTANCES use EM
to open a table on a production server!!!!!
We're reporting on pages vited, by whom, times etc.

So why on earth are you using Enterprise Manager for this???
Aug 4 '06 #16
"Jon" <Jo*@discussions.microsoft.comwrote in message
news:3B**********************************@microsof t.com...
You've been a great help, thank you very much. I can go back to the
business
with this and that they must use Query Analyser.
It's not so much that they *must* use Query Analyser - it's that they *MUST
NOT* use Enterprise Manager :-)
Aug 4 '06 #17

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Colin Steadman | last post by:
Does anyone have a suggestion how I could debug this problem: 1. Data is collected from database and displayed in a form. 2. User updates data and submits it. 3. Submitted data is compared with...
1
by: Eddie | last post by:
I am having a strange issue with MySQL. I just installed it on my Zaurus and loaded a few of my databases in it. All very small. When I do a count withoout a where, it hangs. It does this on all...
0
by: iqbal | last post by:
Hi, I have 2 sql servers (A and B) and have established a link between them using sp_addlinkedserver. I have created a table (test) on sql server A. I have created a view (test) on sql server B...
1
by: Setya Nugraha Djajadinata | last post by:
Hi all, I try to open an mdb and it gives error message : The database 'c:\MyDB\PDz.mdb' needs to be repaired or isn't a database file. You or another user may have been unexpectedly quit...
4
by: Ray | last post by:
I have a split DB running on a network, with code to relink to tables on launch of the client is they are broken. Usually, this works fine, but for some reason just hangs if another user is...
4
by: dave | last post by:
I have an app that uses the OpenFile Dialog class. When I invoke the ShowDialog method, the hourglass appears and just stays. The dialog window never opens. I created a test form with an...
0
by: Jeff | last post by:
Hi - I have an ASP.NET page that hangs (some times; if it loads for you, try refresh/F5 several times) when I try to run it on my localhost. It contains an HTML table for formatting, and within...
2
by: Pierre Rouleau | last post by:
Hi all, I have a consistent test case where os.popen3() hangs in Windows. The system hangs when retrieving the lines from the child process stdout. I know there were several reports related to...
0
by: jeff.dyke | last post by:
I am using ftplib in some code that does exactly what you would expect. It ftp's files. Its running inside a service running on windows xp and windows 2003 servers, approximately 20 installations...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.