Viewing 15 posts - 346 through 360 (of 2,356 total)
I would recommend that these networks be completely separate segments. I would definitely use a static IP address for the heartbeat, as well as the normal traffic. Your networking folks may...
June 21, 2022 at 7:39 pm
Is anyone using Idera's SQL Compliance Manager, or something similar? Auditing requests from our clients is becoming a hot topic. Some of these are kind of ridiculous, but hey, the...
May 26, 2022 at 3:10 pm
Thanks Michael - that approach works fine in normal situation, but doesn't actually protect against this particular usecase as a local windows administrator can simple disable the startup of...
May 25, 2022 at 9:41 pm
I think you are wasting your time. SQL should use all the memory made available to it. You WANT it to use the available memory. I would be concerned if...
May 25, 2022 at 6:32 pm
Set up a SQL job that executes on start up. Create a stored procedure that is executed by this job, and sends an email.
May 25, 2022 at 5:12 pm
Hi
How we can check in a Instance which process is consuming more memory.
Can we release memory without re-starting Sql Server
Thanks
What specifically are you trying to do or solve?
Unless you...
May 25, 2022 at 5:10 pm
Grant the service account full control on the drives that contain the SQL database files. In my case, that's D, L, H, and T
Grant the service...
May 18, 2022 at 1:48 pm
Grant the service account full control on the drives that contain the SQL database files. In my case, that's D, L, H, and T
Grant the service account full...
May 17, 2022 at 1:46 pm
Short version: SQL Agent will not start unless the domain service account is runs under is part of the local admins group on the server. SQL Server, running under...
May 16, 2022 at 2:48 pm
We have a SQL 2019 Failover Cluster Instance - Default Instance. Question seems lame but...
My question is, what is the "Best Practice" on connecting? Directly to the SQL Cluster...
May 16, 2022 at 2:18 pm
I think your idea is a lot of work.
I would create an operator, and the email address would be a group, such as "SQL Notifications". You should rarely have an...
May 16, 2022 at 1:07 pm
Wouldn't posting this on one of the WordPress forums make more sense?
May 12, 2022 at 5:48 pm
If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select...
May 12, 2022 at 5:45 pm
In our environment we have about 10 Always on Set up. The application has configured to connect using listener. The applications are didn't hard coded with server (They are...
May 12, 2022 at 5:28 pm
Why do you have McAfee scanning your database files??? Those should be excluded.
May 12, 2022 at 5:06 pm
Viewing 15 posts - 346 through 360 (of 2,356 total)