Viewing 15 posts - 46 through 60 (of 161 total)
Guys,
From all your responses, it looks like shrinking TEMPDB is worth trying.
My question is:
What should I do right after SHRINKING?
Watch when TEMPDB files starting to grow...
February 21, 2017 at 9:35 am
Hi Kevin,
No. We didn't get "FIXED" Reservation for RAM yet.
It's not going to be busy. I am sure we'll get a lot of resistance from Infrastructure team.
February 21, 2017 at 9:02 am
Kevin,
So our Cache is tiny, I guess.
Can you give me a rough idea of what the numbers should be like in your opinion?
This is today's...
February 16, 2017 at 12:44 pm
Hi bmg002,
Estimated Number of Rows = 1
February 16, 2017 at 11:56 am
Kevin,
I was running this query yesterday
and notice every 2-3 minutes it returns record where granted_memory is like 21GB ?1
And when I get QueryText for that SPID -...
February 16, 2017 at 9:58 am
Kevin,
Resource contention and overload is a KILLER when MX/batch stuff is running.
What do you mean by " ...MX/batch stuff is running" ?
Also , ....
February 16, 2017 at 9:22 am
Richlion2,
In you Query # 2 (-- Top cached queries by Execution Count (SQL Server 2012))
I would look for "low execution count", but at the same time huge...
February 15, 2017 at 1:30 pm
We reboot the whole server (Windows 2012 Server box).
Yes, It's shared memory and I pointed this out to our Infrastructure team already
but they say they are monitoring...
February 15, 2017 at 9:22 am
Some clarification.
It is VIRTUAL MACHINE.
HYPERVISOR.
We do have about 100 active SQL Server Agent jobs running:
every 1 minute --------3-4 jobs
every 10 min ---------- 6 jobs
February 15, 2017 at 8:10 am
So Jeff.
Long story short.
No multiple plans for the same query. Correct?
something is driving things out of cache
EXACTLY!
Sometimes I come in...
February 14, 2017 at 9:07 pm
Jonnathan,
Why ETL would get faster if I shrink TEMPDB files?
February 14, 2017 at 4:11 pm
Perry White,
Can you please explain your comment below?
What does it mean "when buffer pool recharges"?Disk usage will increase as the buffer pool recharges.
February 14, 2017 at 4:02 pm
Finally it's clear!
If you manually grow file,
it will not re-initialize to whatever size was when SQL Server started.
Question.
If you know your tempdb files sizes...
February 14, 2017 at 12:15 pm
Jeff,
About Connection leak.
-------------------------------------
sp_who2 returns 360 rows.
90% of them are sleeping,
5% are BACKGROUND or SUSPENDED.
Do I need to count all of them?
February 14, 2017 at 11:41 am
Jeff,
Is Kevin G. Boles specialty - performance issues?
What is the best way to contact Kevin?
Couple of questions.
Correct me if I'm wrong.
---------------------------------------------------------------------------------------------------------------------------------------------------------
For the same query, SQL Server stores multiple plans in...
February 14, 2017 at 11:25 am
Viewing 15 posts - 46 through 60 (of 161 total)