Viewing 15 posts - 6,631 through 6,645 (of 18,923 total)
Thanks Albaza.
I'll put in an official request for my toy DB and I'll go from there.
We have a test environement but I can't overwrite it at will :crazy:.
April 28, 2011 at 9:21 am
ALZDBA (4/28/2011)
Since you aim for minimal prod sys interference .... let's keep it simple.
How about lightweight tracing just for the the sp_prepare and sp_execute statements (of course...
April 28, 2011 at 8:51 am
Rajat Jaiswal-337252 (4/27/2011)
homebrew01 (4/26/2011)
Ninja's_RGR'us (4/26/2011)
The best alternative is to delete in smaller chunks and run tlog backups within the loop.
Yes, that is how I do it, with no problems. ...
April 28, 2011 at 8:07 am
Just got a reply from Adam and there's no way to use his script to do what I need (unless I'm prepared to start an infinite loop and kill it...
April 28, 2011 at 8:06 am
Tx, I had forgotten about that script... That is definitely something that could help!
Actually this seems like a better download link :
April 28, 2011 at 7:49 am
Jack Corbett (4/28/2011)
April 28, 2011 at 7:15 am
Jack Corbett (4/28/2011)
Yeah, there might be too much load, but I thought it might be an option and more lightweight than a trace.
I've tested that option in another project and...
April 28, 2011 at 7:02 am
Jack Corbett (4/28/2011)
Yeah. But you could get SHOWPLAN_XML and I think you can do some pretty complex filtering. Might be worth looking at.
Similar issue here... prod server with...
April 28, 2011 at 6:44 am
Ya and assuming you only have 16 months of data in there, that means you're likely flushing out 150 to 250 million rows.
At that point I'd consider partitioning and simply...
April 28, 2011 at 6:41 am
I don't see anything usefull in there in the events list. The closest thing might be cache_insert.
Anything else would scare the life out of me... getting millions of rows...
April 28, 2011 at 6:37 am
My other challenge here is that when I run a report or whatever so that I can see what's going on. The statements seem to already have been prepared...
April 28, 2011 at 6:07 am
Brandie Tarvin (4/28/2011)
Ninja's_RGR'us (4/27/2011)
While we're at it... is there any way (other than a trace) to see all the queries run by a session between 2 dates?
Not by a trace?...
April 28, 2011 at 5:59 am
Got a hard 1 for you all. Get me all the queries sent through sp_prepare and executed via sp_execute (not sp_executesql).
http://www.sqlservercentral.com/Forums/Topic1099625-146-1.aspx
April 27, 2011 at 5:05 pm
Peter Maloof (4/27/2011)
I'd love it if a manager would post here, trying to justify their company's telecommuting...
April 27, 2011 at 5:02 pm
Peter Maloof (4/27/2011)
UMG Developer (4/27/2011)
The official policy is B, but unofficially they want exempt employees to do A (still using sick time), and want non-exempt employees to do C.
They expect...
April 27, 2011 at 3:10 pm
Viewing 15 posts - 6,631 through 6,645 (of 18,923 total)