all bout dat'base, no sql

Remove Foglight Performance Analyzer for SQL Server middle ware

REM  Run as administrator

"C:\Program Files\Quest Software\pa_agent\3566\agents\bin\quest_launcher.exe" 3566 "+C:\Program Files\Quest Software\pa_agent\3566\agents" -unregister




https://support.software.dell.com/performance-analysis-for-oracle/kb/44712

low free memory

Check your servers "free" memory, all the available memory may be tied up in cache due to copying files to/from your server

Create a file the size of your available memory or larger.

fsutil file createnew r:\backup\2gb.txt 2147483648

Then copy the file and then permanently delete both the original and the copy. (Delete from command line, use shift + delete, and/or empty the trash bin)

Now all available memory should be free :)

15404 Could not obtain information about Windows NT group/user

Error message:

03/03/2015 12:43:09,spid28s,Unknown,An exception occurred while enqueueing a message in the target queue. Error: 15404 State: 19. Could not obtain information about Windows NT group/user 'domain\svc_name' error code 0x5.
03/03/2015 12:43:09,spid28s,Unknown,Error: 28005 Severity: 16 State: 2.


Diagnosis:

Can confirm this by executing the following SQL:


xp_logininfo 'domain\svc_name'


Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'domain\svc_name', error code 0x5.



Resolution:

A: Give the “Authenticated Users”  “Read Permissions” on the ADFS service account.

-or-

B: Add the SQL Server service account or "Authenticated Users" to the "BULTIIN\Windows Authorization Access Group" in AD for the domain

-or- 

C: Add the SQL Server service account or "Authenticated Users" to the "BULTIIN\Pre-Windows 2000 Compatible Access" in AD for the domain


References:

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_6635.html

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_4905.html

http://blog.matticus.net/2009/08/windows-2008-and-xplogininfo.html

SQL Server Default Trace 0

--To see if default trace is enabled
SELECT* FROM sys.configurations WHERE configuration_id = 1568


--To enable default trace
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'default trace enabled', 1;
GO
RECONFIGURE;
GO


--To query contents of default trace file
SELECT TE.*
     , T.*
  FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150)

       , ( SELECT TOP 1 f.[value]
             FROM sys.fn_trace_getinfo(NULL) f
            WHERE f.property = 2)), DEFAULT) T
  JOIN sys.trace_events TE 
    ON T.EventClass = TE.trace_event_id

More info:

http://www.databasejournal.com/features/mssql/a-few-cool-things-you-can-identify-using-the-default-trace.html

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

The Target Principal Name Is Incorrect. Cannot Generate SSPI Context

Setting up an instance of SQL Server 2008 R2 64bit Standard, got this error when trying to connect from off the server.

Still working to determine the cause, in the meantime was able to temporarily remedy by disabling names pipes and setting service account to "LocalSystem".

Connection String Variations

.\instance
(local)\instance
127.0.0.1\instance - loopback
servername\instance
ip\instance
ip,port
tcp:servername\instance - tcp/ip
lpc:servername\instance - shared memory
np:servername\instance - named pipes