Viewing 15 posts - 5,851 through 5,865 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2015 at 12:33 am
1) Identify why the log isn't been reused and why it's not growing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2015 at 12:30 am
Tom_Sacramento (5/20/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2015 at 12:17 pm
audiocool (5/20/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2015 at 12:19 am
High cpu-consuming queries. Identify the queries and tune them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2015 at 12:15 am
Viewing 15 posts - 5,851 through 5,865 (of 49,552 total)