Blocking Question

I am beginning to see blocked and blocking processes in
Lock / Process ID tab under the current activity window.
SQL Server resolves this after a while but is this
normal ' If not how can I resolve the blocking problems '
Database is a highly transactional ~500 user database.
Thanks for any feedback.Blocking is OK, as long as there's no dead lock. If one process opens a
transaction and then the second process try to access the same tables
used by the first one, the second process will be blocked. It will just
sit there and wait until the first process finish its job (commit or
rollback), so it's normal.
--
Eric Li
SQL DBA
MCDBA
Nick wrote:
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ' If not how can I resolve the blocking problems '
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.|||Just to add a little to Eric's answer. A little bit of blocking is normal
and can be OK as long as it doesn't wait too long. If your seeing a lot of
blocking you may need to tune some of your statements or indexes some.
--
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eDAeTbPREHA.1048@.tk2msftngp13.phx.gbl...
> Blocking is OK, as long as there's no dead lock. If one process opens a
> transaction and then the second process try to access the same tables
> used by the first one, the second process will be blocked. It will just
> sit there and wait until the first process finish its job (commit or
> rollback), so it's normal.
> --
> Eric Li
> SQL DBA
> MCDBA
> Nick wrote:
> > I am beginning to see blocked and blocking processes in
> > Lock / Process ID tab under the current activity window.
> > SQL Server resolves this after a while but is this
> > normal ' If not how can I resolve the blocking problems '
> >
> > Database is a highly transactional ~500 user database.
> >
> > Thanks for any feedback.
>|||Hi,
Have a look into thebelow article which explains the strategies to reduce
blocking:-
http://www.sql-server-performance.com/sf_block_prevention.asp
Have a look into the below link as well to reduce locks
http://www.sql-server-performance.com/reducing_locks.asp
Thanks
Hari
MCDBA
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:1491601c444f2$f95cf610$a001280a@.phx.gbl...
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ' If not how can I resolve the blocking problems '
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.|||Thanks to All.........
>--Original Message--
>I am beginning to see blocked and blocking processes in
>Lock / Process ID tab under the current activity window.
>SQL Server resolves this after a while but is this
>normal ' If not how can I resolve the blocking
problems '
>Database is a highly transactional ~500 user database.
>Thanks for any feedback.
>.
>

Blocking Question

I am beginning to see blocked and blocking processes in
Lock / Process ID tab under the current activity window.
SQL Server resolves this after a while but is this
normal ? If not how can I resolve the blocking problems ?
Database is a highly transactional ~500 user database.
Thanks for any feedback.
Blocking is OK, as long as there's no dead lock. If one process opens a
transaction and then the second process try to access the same tables
used by the first one, the second process will be blocked. It will just
sit there and wait until the first process finish its job (commit or
rollback), so it's normal.
Eric Li
SQL DBA
MCDBA
Nick wrote:

> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ? If not how can I resolve the blocking problems ?
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.
|||Just to add a little to Eric's answer. A little bit of blocking is normal
and can be OK as long as it doesn't wait too long. If your seeing a lot of
blocking you may need to tune some of your statements or indexes some.
Andrew J. Kelly
SQL Server MVP
"Eric.Li" <anonymous@.microsoftnews.org> wrote in message
news:eDAeTbPREHA.1048@.tk2msftngp13.phx.gbl...
> Blocking is OK, as long as there's no dead lock. If one process opens a
> transaction and then the second process try to access the same tables
> used by the first one, the second process will be blocked. It will just
> sit there and wait until the first process finish its job (commit or
> rollback), so it's normal.
> --
> Eric Li
> SQL DBA
> MCDBA
> Nick wrote:
>
|||Hi,
Have a look into thebelow article which explains the strategies to reduce
blocking:-
http://www.sql-server-performance.co...prevention.asp
Have a look into the below link as well to reduce locks
http://www.sql-server-performance.co...cing_locks.asp
Thanks
Hari
MCDBA
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:1491601c444f2$f95cf610$a001280a@.phx.gbl...
> I am beginning to see blocked and blocking processes in
> Lock / Process ID tab under the current activity window.
> SQL Server resolves this after a while but is this
> normal ? If not how can I resolve the blocking problems ?
> Database is a highly transactional ~500 user database.
> Thanks for any feedback.

Blank window Problem

Hi everyone...
I ve a problem that is-
Scenario:
I open report using url access from html page. Parameters are passed in from
html page as hidden fields. Url of report is in Action attribute of form in
the page. So, when i submit it it opens BLANK WINDOW and the opens prompt
window for saving or opening option.
Problem:
I dont want this blank window.
Please help! I am looking replies from MS guys as i couldnt find it anywhere!
--
Suneet Mohan
Microsoft Certified ProfessionalOn Sat, 2 Apr 2005 10:51:02 -0800, Suneet <suneetmohan@.gmail.com>
wrote:
>Hi everyone...
>I ve a problem that is-
>Scenario:
>I open report using url access from html page. Parameters are passed in from
>html page as hidden fields. Url of report is in Action attribute of form in
>the page. So, when i submit it it opens BLANK WINDOW and the opens prompt
>window for saving or opening option.
>Problem:
>I dont want this blank window.
>Please help! I am looking replies from MS guys as i couldnt find it anywhere!
>--
>Suneet Mohan
>Microsoft Certified Professional
It would be helpful to see the URL that is created and which seems to
fail.
Andrew Watt
MVP - InfoPath

blank query window- how to get?

In Sql Server Query Analyzer, to get a blank query window, it seems that I
must first edit an existing stored procedure, at which point the "New
window" button is enabled.
Is there a way to get an empty window without first having to edit another
query? If I launch Query Analyzer, I have an empty instance of the app..how
do I get a blank query window?
thx1. You must be connected to an instance of sqlserver.
2. [ctrl]+[N] should open a new window/connection to the connected instance.
-oj
"mrmagoo" <-> wrote in message news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> In Sql Server Query Analyzer, to get a blank query window, it seems that I
> must first edit an existing stored procedure, at which point the "New
> window" button is enabled.
> Is there a way to get an empty window without first having to edit another
> query? If I launch Query Analyzer, I have an empty instance of the
> app..how
> do I get a blank query window?
> thx
>|||that's my point...it doesn't.
I launch query analyzer, and pick the server. It connects.
By default it does open an empty query window. If I close that, there's no
way that I can see to get another one unless I edit another stored
procedure. THEN I can Ctrl + N to get as many new windows as I want.
"oj" <nospam_ojngo@.home.com> wrote in message
news:udqvtV6TGHA.224@.TK2MSFTNGP10.phx.gbl...
> 1. You must be connected to an instance of sqlserver.
> 2. [ctrl]+[N] should open a new window/connection to the connected
instance.
> --
> -oj
>
> "mrmagoo" <-> wrote in message
news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
I
another
>|||When you close the last window, there is nothing left in "query window"
cache to use to reinitiate a new connection for another query window. This
is by design and would not be enhanced - QA is now replaced with Management
Studio (sqlwb) in sql2k5.
-oj
"mrmagoo" <-> wrote in message news:eGUfXo6TGHA.4740@.TK2MSFTNGP14.phx.gbl...
> that's my point...it doesn't.
> I launch query analyzer, and pick the server. It connects.
> By default it does open an empty query window. If I close that, there's no
> way that I can see to get another one unless I edit another stored
> procedure. THEN I can Ctrl + N to get as many new windows as I want.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:udqvtV6TGHA.224@.TK2MSFTNGP10.phx.gbl...
> instance.
> news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> I
> another
>|||ok..thanks...
"oj" <nospam_ojngo@.home.com> wrote in message
news:eGk2Jk8TGHA.4900@.TK2MSFTNGP12.phx.gbl...
> When you close the last window, there is nothing left in "query window"
> cache to use to reinitiate a new connection for another query window. This
> is by design and would not be enhanced - QA is now replaced with
Management
> Studio (sqlwb) in sql2k5.
> --
> -oj
>
> "mrmagoo" <-> wrote in message
news:eGUfXo6TGHA.4740@.TK2MSFTNGP14.phx.gbl...
no
>|||"mrmagoo" <-> wrote in message news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> In Sql Server Query Analyzer, to get a blank query window, it seems that I
> must first edit an existing stored procedure, at which point the "New
> window" button is enabled.
> Is there a way to get an empty window without first having to edit another
> query? If I launch Query Analyzer, I have an empty instance of the
> app..how
> do I get a blank query window?
> thx
>
CTRL+O
or
Select File / Connect...
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||thanks!
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eYLv$gEUGHA.2444@.TK2MSFTNGP14.phx.gbl...
> "mrmagoo" <-> wrote in message
news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
I
another
> CTRL+O
> or
> Select File / Connect...
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

Blank browser window when exporting to PDF

Hi:
Is there any way to avoid the blank browser window we see when exporting a
report to pdf?
I'll prefer to download the pdf on the same window to save it to the disk,
or to open it on another browser window using the acrobat reader plugin, but
what reporting services is doing is sending a request to download the report
on a new window, so after finishing the download, the user has to close this
window.
Any solutions?
Thanks,
Daniel Bello UrizarriI do not know what happens to you, here is what happend with my browser
(IE7.0, but it behaved the same when I used IE6):
1. In report viewer, choose export to PDF (or any other exporting format)
and click "Export";
2. A blank Browser window pops up followed by "File Download" dialog box
with button "Open", "Save", and "Cancel";
3.
a. If you choose "Open", the report is opened inside the new browser
window;
b. If you choose "Save" or "Cancel", the newly opened browser CLOSES
automatically. Of course, when you choose "Save", "Save File" dialog box
pops up while the blank browser window closes.
It must be something wrong with your browser/or setting being changes, such
as certain type of client-side script were disabled..., if it does not close
the blank window automatically.
"Daniel Bello" <dburizarri@.yahoo.es> wrote in message
news:eZ0bdYioHHA.5052@.TK2MSFTNGP04.phx.gbl...
> Hi:
> Is there any way to avoid the blank browser window we see when exporting a
> report to pdf?
> I'll prefer to download the pdf on the same window to save it to the disk,
> or to open it on another browser window using the acrobat reader plugin,
> but what reporting services is doing is sending a request to download the
> report on a new window, so after finishing the download, the user has to
> close this window.
> Any solutions?
> Thanks,
> Daniel Bello Urizarri
>|||Norman:
In my PC (and most of the others in my company) the browser window never
gets closed. If I click "Open", an instance of the Acrobat Reader standalone
application is started. If I click on "Save" or "Cancel", after the file
download dialog closes, the browser window remains there. I have IE 6 and
Acrobat Reader 7.
Do you have any ideas about where to look on the browser configuration to
change this behavior?
Thanks,
Daniel Bello Urizarri.
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23WJPd6ioHHA.3880@.TK2MSFTNGP04.phx.gbl...
>I do not know what happens to you, here is what happend with my browser
>(IE7.0, but it behaved the same when I used IE6):
> 1. In report viewer, choose export to PDF (or any other exporting format)
> and click "Export";
> 2. A blank Browser window pops up followed by "File Download" dialog box
> with button "Open", "Save", and "Cancel";
> 3.
> a. If you choose "Open", the report is opened inside the new browser
> window;
> b. If you choose "Save" or "Cancel", the newly opened browser CLOSES
> automatically. Of course, when you choose "Save", "Save File" dialog box
> pops up while the blank browser window closes.
> It must be something wrong with your browser/or setting being changes,
> such as certain type of client-side script were disabled..., if it does
> not close the blank window automatically.
> "Daniel Bello" <dburizarri@.yahoo.es> wrote in message
> news:eZ0bdYioHHA.5052@.TK2MSFTNGP04.phx.gbl...
>> Hi:
>> Is there any way to avoid the blank browser window we see when exporting
>> a report to pdf?
>> I'll prefer to download the pdf on the same window to save it to the
>> disk, or to open it on another browser window using the acrobat reader
>> plugin, but what reporting services is doing is sending a request to
>> download the report on a new window, so after finishing the download, the
>> user has to close this window.
>> Any solutions?
>> Thanks,
>> Daniel Bello Urizarri
>