April 8, 2013 at 1:28 pm
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.
April 8, 2013 at 1:47 pm
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.April 8, 2013 at 1:55 pm
Yes. Standalone database running on the same server production
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply