Tag Info

New answers tagged

0

Simple way to import .trc file without any errors by opening file into SQL Profiler tool -> File -> Save as -> Trace Table -> SQL Table import option will pop up. Good Luck


0

All uses of that table will run faster (some will run a lot faster) if you jettison id and make name the PRIMARY KEY. Your UPDATE is currently looking in 2 BTrees, plus updating 2 BTrees. The PK change would change those to 1 and 2. More importantly it would simply the row locking. How big is the table? How much RAM do you have? What is the value of ...


6

Getting the SQL from a DDL Trigger for whatever query that is dropping this Stored Procedure will only help so much. If the query is coming from Dynamic SQL from a Stored Procedure, or from a release script, or an integration test, application code, etc, then you will likely only capture the DROP PROCEDURE ... which doesn't give much of a clue as to where ...


0

I'm using Profiler 2012, talking to 2008, 2008 R2, and 2012 databases. I had to use a slightly different workflow than in the accepted answer. When I try to follow that workflow, to migrate a template from 2008 to 2012, the Select template name dropdown depopulates, and clicking Save or Save As prompts me to choose a template to save. Instead, copy your ...


2

On a pretty large dataset I tested a query that times out after 10 seconds: db.collection.find({"foo": "bar"}).maxTimeMS(10000) (In my case the collection has > 100 GB of data and no index on the field foo). I searched for the query using: db.system.profile.find({"query.query" : { "foo" : "bar" }}).limit(5).sort({ts: -1}).pretty() and found that the ...


1

MongoDB targets operations for termination if the associated cursor exceeds its allotted time limit(maxTimeMS). I believe the few millis more come from two things. 1) There should be an internal process that checks periodically so you will get the check interval overhead (for example every 1ms) 2) MongoDB terminates operations that exceed their allotted ...



Top 50 recent answers are included