Forum Replies Created
Viewing 15 posts - 841 through 855 (of 7,504 total)
-
Reply To: How to find index usage by stored procedure?
FWIW the execution plan will show the indexes it plans use ( and estimates or actual usage values )
-
Reply To: Powershell script giving the error "The specified value 'Patch' is invalid."
Also keep this note in mind: "...optional for computers that do not host Microsoft SQL Server Reporting Services."
-
Reply To: Powershell script giving the error "The specified value 'Patch' is invalid."
You only need to provide the latest CU.
It includes all others !
-- added --
At install time ( of a sqlserver instance ) , you can indeed point to a path...
-
Reply To: Powershell script giving the error "The specified value 'Patch' is invalid."
I think you just have to start from the actual CU you are trying to install:
Set-Location 'E:\SQL_2019\patches'
SQLServer2019-KB4577194-x64.exe /ACTION=Patch /ALLINSTANCES /QUIETSIMPLE /IACCEPTPYTHONLICENSETERMS /IACCEPTROPENLICENSETERMS /IACCEPTSQLSERVERLICENSETERMS -
Reply To: High CPU and plan cache instability
Just my 2ct: Check this value.
Maybe activating this setting can take some pressure of your plan cache because it only has to calculate the stub and not actually put it...
-
Reply To: Alert Mechanism
Of course, a monitoring product is nice and fine and $$
But, if you are on a 0 budget, you could start the KISS way:
( we always install as DBA DBMail...
-
Reply To: Allowing Failure
for what it's worth ...
- it took me 5 years to get our apps to a state that sysadmin was no more needed and no non-dba had sysadmin at OS...
-
Reply To: Are the posted questions getting worse?
Jeff Moden wrote:...
I farted, it made a sound... and I didn't have to change my underwear! 😀
...
MADE MY DAY ! ! 😀
-
Reply To: Do *not* place TEMPDB on a local disk in a SQL failover cluster
Thank you for sharing this estonishing "story from the trenches".
Happy new year.
-
Reply To: Help with Actual execution Plan
I think you forgot to pose the question related to this execution plan.
Just reply the question and attach the .sqlplan renamed to .txt file.
Happy new year !
-
Reply To: Error connecting to sql using listener name only
Why did you configure that many Listeners ?
A listener is a AD object, managed by your windows cluster.
A single one could be sufficient to have you AG available
listeners-client-connectivity-application-failover
Viewing 15 posts - 841 through 855 (of 7,504 total)