sql server 2012 – Extended Events Perfmon Counters

I’d like to use the perfmon OS counters from Extended Events if possible as they require less intervention from other teams, I’ve created a session with perfobject_process, perfobject_logicaldisk,
perfobject_system, perfobject_processor events and when trying to manipulate the data for metrics such as percent_processor_time they don’t seem to make sense. This is after subtracting the most current value from the last. Is there any documented means that I can properly use this data?

audio – MacBook Pro (13-inch, Mid 2012) does not recognise Yamaha YHT-1840

I connected my MacBook using MiniDisplay+HDMI cable to input port on a receiver.
I connected my Projector to output port on receiver.

All works great I can see a video and I can hear 5.1 audio.

But when I switch off a projector or unplug it at all MacBook stop seeing a receiver.

I would like to play just music for example without running projector.

When I switch off projector the output looks like this:
enter image description here

Do I need projector to be switched on every time to hear a sound?

SQL Server 2012 Database engine failed to install everytime

I am trying to install SQL Server 2012 -64 bit in our dev server running Windows Server 2012. Everytime, Database engine fails to install. I’ve checked the event logs it shows.

Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file ‘e:sql11_main_t.obj.x86releasesqlmkmastrdatabasesobjfrei386modellog.ldf’. Diagnose and correct the operating system error, and retry the operation.

I followed the link- SQL Server express service is not starting to resolve the issue. I opened command prompt and run the command – NET START MSSQL$SQLEXPRESS /f /T3608

But it throws the error – The service name is invalid.

Has anyone gone through this issue. Please suggest a solution for this issue.



sql server – Why restored SQL 2012 Database on SQL 2016 significantly larger then SQL 2012 Database?

Question about restored SQL 2012 database on SQL 2016 and backed up again on SQL 2016.
I’ve backed up SQL 2012 database that is 33 MB in size.
Then, restored it on SQL 2016 and created another backup but this time on SQL 2016.
The size of the backup changed from SQL 2102 backup file of 33MB to 315MB backup file size on SQL 2016.

Why such big increase to the size of the backup file on the SQL 2016?

Appreciate any help.

Mac Mini Server (Late 2012) | 2.3 GHz Quad-Core i7 | 16GB 1600MHz DDR3 | macOS Catalina

I am on a Mac Mini with a 1TB SSD. After a few years my SSD is running out of space, while I keep all my user data on an external drive. My system is loaded with Multimedia Apps Photoshop, Final Cut Pro, Logic Pro X, Garage Band and many others.
When trying to find the file(s) that can be removed on the SSD, using CleanMyMac X function of Space Lens, I bump into a very large file in /Users/username/Library/Group Containers/group.com.lminhtm.tempmonitor/db.realm. This file is a whacking 378GB!
Through Google searches I can’t find any mention of this file.
Does anyone have a suggestion?

sql server 2012 – Permission to select sys tables in stored procedure

I have implemented the stored procedure to check if a specific (schema).(procedure) exists.

CREATE PROCEDURE (BlobCheckExisting).(usp_DoesStoredProcedureExist) 
@schemaName varchar(128),
@procedureName varchar(128)
SELECT IIF (EXISTS (SELECT 1 FROM sys.procedures p INNER JOIN sys.schemas s ON p.(schema_id) = s.(schema_id) 
    WHERE s.(name) = @schemaName  AND p.(name) = @procedureName), 1, 0)

When I tested with sa it selected 1 as I expected but when I tried with a minimum permission account which only granted EXECUTE to the procedure, it selected 0.

My assumption of stored procedure mechanism was role/user only requires EXECUTE to perform the procedure.
We don’t need to concern the permission setting of each DB object like CRUD to table and so on.

But it seems sys tables are exceptions? Or did I miss anything?
Moreover, If I don’t want to grant select sys.procedures/sys.schemas to the role. I just want my procedure to work as expected, what should I do?