Viewing 15 posts - 1 through 15 (of 279 total)
Without any license you could only install SQL Express 🙂
For any other SQL you need licenses and for any HA (eg. SQL Cluster)/DR solution you need that these licenses will...
June 14, 2021 at 8:31 am
Hi, are you able to connect from node02 to node01 using ssms or sqlcmd? SQL port is open between these two nodes?
June 7, 2021 at 8:28 pm
Hi, how you are doing this backups? Manual, SSIS task or some procedure eg. Ola Hallengren? What with backup files, are they generated? You may making log backups on other...
June 7, 2021 at 12:26 pm
Hi, check resource utilization especially IO (disk latency, disk queue length), CPU or SQL dumps. It is often caused by SQL extremely high IO resource utlizaiton, so high that Windows...
June 5, 2021 at 11:15 am
You can still use sp_WhoIsActive when the query is executing to check what kind of waits are slowing down the query or status whatever it is running/runnable or else in...
May 27, 2021 at 7:14 pm
Hi, few cases that may occur on primary especially when index rebuild was running are:
select * from sys.dm_exec_requests where blocking_session_id>0?
May 26, 2021 at 9:42 am
Hi, this is correct behavior dtexec.exe is a command line tool to call ssis packages if you want GUI version DTExecUI.exe you should have it installed with SSMS eg. C:\Program...
May 26, 2021 at 8:44 am
"The msdb mdf files were copied and restored, but the jobs were built from scratch in the new DB." so here is yours problem. This is not supported method for...
May 22, 2021 at 10:52 am
Hi, error message is clear 🙂 but you can confirm this with Azure support team.
May 21, 2021 at 8:16 pm
any errors in sqlagent error log? Jobs during migration were scripted and recreated or msdb mdf files were copied?
Any trigers on system tables in msdb database?
Any session blocked in sys.dm_exec_requests?
May 21, 2021 at 8:09 pm
You can query details using sys.dm_db_stats_properties https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-stats-properties-transact-sql?view=sql-server-ver15
SELECT sp.stats_id, name, filter_definition, last_updated, rows, rows_sampled, steps, unfiltered_rows, modification_counter FROM sys.stats AS stat CROSS APPLY...
May 19, 2021 at 7:39 pm
Hi, you got correct query in first response from https://stackoverflow.com
SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID('YourDatabaseName')
the session that is using DB will be holding...
May 19, 2021 at 7:33 pm
Hi, cluster require votes majority to stay online in your case 3 nodes in DC1 has majority, check Node & File Share Majority Quorum configuration mode in the Windows Failover...
May 18, 2021 at 8:52 am
probably best will be using some group email, if not you can add multiple email addresses separeted by ; to operator but be careful because there is characters limit if...
April 17, 2021 at 8:34 pm
1. Double/triple check the sids because looks like they differ if there are no matching, or if you can just recreate them using sp_help_revlogin proc
2. Check the error log during...
April 17, 2021 at 8:30 pm