Get the number of connections to a database

SELECT db_name(dbid) as DatabaseName, count(dbid) as NumberOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

Comments

Post a Comment

Popular posts from this blog

Corporate Intranet Information Architecture – a Publishing Site

Image
There have been several occasions in my consulting career where I have discussed what a corporate intranet should look like.   There are several aspects to this question, branding, custom web parts or other bells and whistles, but I believe that the fundamental structure or information architecture is one of if not the most important aspect of a solid, useful corporate intranet. Clearly, each individual company will have a unique look and feel and information architecture.   This will depend on the underlying business as well as the relative size, geographical locations and languages of the company. However, I have noticed certain commonalities across companies and have started to develop a template of how I can help an organization visualize there corporate intranet.   This could be used as a target to reorganize an existing intranet or as a template to stand up a new one.   In either case, changes will have to be made to suit the individual company’s nee...
Read more

Metastorm - Open form in an action from a list or link

Below is the SQL underneath the custom list with the link to open an action.  If you are opening from outside of a Metastorm client, you may need to add the ‘SessionID’ parameter containing a valid session ID 9.  I haven’t tried this with the current 9.1 SSO, it may be unnecessary.   If the session id parameter is still necessary, usually we write a wrapper aspx page to authenticate to user, grab the session id and redirect them to the action. The syntax is http://<servername/Metastorm/eForm.aspx?Map=<process map name>&Action=<action name>&Folder=<folder name>&FolderID=<folderid>&Service=<BPM Service Name>&Client=External&FolderLaunchURL=&FolderCancelURL=&IsFolderAction=True SELECT eFolder . eFolderID , eFolder . eFolderName , eFolder . eStageName ,   eFolder . eUpdated , eFolder . eSubject , ITProjectInitiation . txtProjectName ,   CASE       WHEN LEN ( IT...
Read more

The long sad road to getting Metastorm, SharePoint, and Kerberos to work together in a multiple server farm.

Sorry the Screen shots did not come in... I didn't want to put in the time to add each one, maybe I will do it later. Introduction This troubleshooting guild is born of the issues encountered when installing the Metastorm BPM product in the <YourCompany> environment.   This will not replace the metastorm documentation, but is intended to be supplemental. First off make sure the engine starts.   If it does not start check component services and make sure the account you are running the engine off is enabled.   If this doesn’t work unstill and reinstall Metastorm, make sure to delete the registry entries and the files under program files as the uninstall leaves bit’s of the program all over the place.   If this still does not work, blow away the server and try again.   The install of Metastorm should take only about an hour, if you have spent more than three, start over. Single Sign On (SSO) The SSO instructions in the Metastorm Administration guide are rel...
Read more