Viewing 15 posts - 5,866 through 5,880 (of 22,211 total)
Almighty (7/3/2015)
but we can use profiler remotely or as u said by using TSQL right ? extended events are good but for earlier version profiler was better idea
Nope. Running...
July 3, 2015 at 6:02 am
GilaMonster (7/3/2015)
TomThomson (7/3/2015)
But don't make the mistake of thinking that all-nighters are always a sign of problems, or long hours (how can long hours be "heroic"?).
No, I'm not talking...
July 3, 2015 at 5:59 am
Almighty (7/3/2015)
USE PROFILER .. TO FIND OUT WHAT HAPPEN S AT FIRST TIME THEN ANALYIZE THAT
This is actually really bad advice on two levels. First, running the Profiler GUI...
July 3, 2015 at 4:06 am
It could be compile time on the query is very high which can cause some blocking, or that it's loading a lot of data into memory, again, possibly causing blocking....
July 3, 2015 at 4:02 am
If the execution plans are the same then it's likely down to resources. Take a look at the waits statistics before and after the run in order to determine the...
July 3, 2015 at 3:56 am
HanShi (7/2/2015)
Grant Fritchey (7/2/2015)
July 2, 2015 at 3:51 pm
GilaMonster (7/2/2015)
Do you get the feeling that IT people, especially ones at the top-end of the field, are...
July 2, 2015 at 3:49 pm
The AdventureWorks databases are almost never released before the product. I know this because every time I'm working on a book prior to the release I have to use the...
July 2, 2015 at 11:31 am
Cost threshold for paralellism is a value based on the estimated cost of the execution plan created by the query optimizer. The cost values, once upon a time (we're talking...
July 2, 2015 at 11:28 am
I stopped maintaining the home lab and moved it all to Azure. So much easier to get everything I need fast, no upgrades necessary, nothing to maintain. The only pain...
July 2, 2015 at 11:20 am
There is absolutely no hard and fast rule on this at all. It just depends on your data, how fast it comes in, and how much the data changes are...
July 2, 2015 at 10:23 am
Don't run Profiler on a production server. Profiler is for consuming the data, not doing the monitoring.
To capture the information with the least possible hit on your server, use extended...
July 2, 2015 at 10:19 am
ramana3327 (7/2/2015)
Capturing the transactions 1-2 hrs from production and...
July 2, 2015 at 10:03 am
Since I am usually the harbinger of ill tidings on the thread, you guys should know, Skynet seems to be going live.
July 2, 2015 at 8:25 am
When I taught classes like this where all we were doing was querying, instead of setting up Express (not a bad idea, just not what I needed), I created a...
July 2, 2015 at 7:25 am
Viewing 15 posts - 5,866 through 5,880 (of 22,211 total)