Viewing 15 posts - 5,851 through 5,865 (of 49,571 total)
audiocool (5/21/2015)
Hi Gail,CPU and Memory Usage:
USe Process Explorer (not resource monitor), it's a download from MS, or perfmon (Performance Monitor) counters. Task manager and resource monitor are for quick looks...
May 21, 2015 at 3:42 am
Definitely a poor practice (it's confusing) and only works with DATETIME, not DATE, NOT DATETIME2, not DATETIMEOFFSET
May 21, 2015 at 12:35 am
Firstly decide whether you need to worry. VLFs aren't a bad thing, they're how the log is architected. The only problem is when you have excessive numbers.
How big's the log...
May 21, 2015 at 12:33 am
1) Identify why the log isn't been reused and why it's not growing.
May 21, 2015 at 12:31 am
Don't use Task Manager to check memory usage, it's often wrong because it doesn't include some memory areas. Process Explorer is great, otherwise use perfmon counters.
May 21, 2015 at 12:30 am
Tom_Sacramento (5/20/2015)
May 20, 2015 at 2:31 pm
Eric M Russell (5/20/2015)
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
SELECT TOP 10 without any kind of ORDER BY or WHERE clause? If so, that's going to result in an index scan.
Shouldn't be...
May 20, 2015 at 1:06 pm
Eirikur Eiriksson (5/20/2015)
This would be the one that wants to fix ugly queries with a sprinkle of hint perfume when all that's needed is a good shower/rewrite.😎
It appears I haven't...
May 20, 2015 at 12:59 pm
Grant Fritchey (5/20/2015)
SELECT TOP 10 without any kind of ORDER BY or WHERE clause? If so, that's going to result in an index scan.
Shouldn't be too much of a...
May 20, 2015 at 12:29 pm
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!I could see this one coming miles away, surprised how long it took.
😎
If it's the one I'm thinking of, I hit that stage this morning,...
May 20, 2015 at 12:19 pm
Almighty (5/20/2015)
GilaMonster (5/20/2015)
Almighty (5/20/2015)
as said earlier .. check the reason of log not shrinkingin log _reuse_wait column
Log_reuse_wait has nothing to do with the log not shrinking. It...
May 20, 2015 at 12:17 pm
audiocool (5/20/2015)
May 20, 2015 at 12:01 pm
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are...
May 20, 2015 at 11:52 am
Almighty (5/20/2015)
The Open Query Is also an option for you i guessgoogle something on Openquerry
OpenQuery uses linked servers to query across servers.
May 20, 2015 at 12:19 am
High cpu-consuming queries. Identify the queries and tune them.
May 20, 2015 at 12:15 am
Viewing 15 posts - 5,851 through 5,865 (of 49,571 total)