Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

tempdb Expand / Collapse
Author
Message
Posted Monday, April 08, 2013 1:28 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi,

Our monitoring tool has reported that blocking on prodution

i checked the details

one user is running adhoc query on standalone database(not production database)

one more query is running by the same user against tempdb

SELECT SCHEMA_NAME(tbl.schema_id) AS [Schema], tbl.name AS [Name] FROM sys.tables AS tbl WHERE (tbl.name not like '#%') ORDER BY [Schema] ASC,[Name] ASC

is this Intellisense feature? (which helps the user to make correct SQL Queries)

one of production process (running aginst production db) is blocked by this user temp db query.



So my question is user is trying to run adhoc query in standalone database and production db process is blocked. Just trying to understand how SQL works (because nothing in appln client or our server processes accesses this standalone databse)


Please clarify.
Post #1440001
Posted Monday, April 08, 2013 1:47 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
Please follow link next to find out how to monitor blocking locks... http://support.microsoft.com/kb/271509 - That would tell you who is blocking who.

Out of curiosity... is standalone database running on the same server production is? what's the purpose of such standalone database?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1440005
Posted Monday, April 08, 2013 1:55 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Yes. Standalone database running on the same server production
Post #1440012
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse