SCOM is amazing, but expensive and very hard to configure - properly.

http://msdn.microsoft.com/en-us/library/ms366332.aspx

I do believe you can hit non SQL WMI counters ... I am looking into this myself.

Not sure If I'm following you here ...

sysjobs:

- job_id = 24DB313E-72ED-49CD-A811-4462A66A0367

sysjobsteps:

- step_uid = 55060C17-0964-459C-A338-9ADF1C40384F

sysprocesses:

- program_name = 0x3E31DB24ED72CD49A8114462A66A0367

How can I get that program_name to match up to the job or the...

Not the same number there either.

step_uid = 55060C17-0964-459C-A338-9ADF1C40384F

sysprocesses program_name = 0x3E31DB24ED72CD49A8114462A66A0367

Negative,...

Anyone?

Can't say I have any experience with it, but you can create your own custom counters via SQLServer:User Settable. Might be able to tie into CLR or some extended stored...

Not sure I even answered what you were asking ... are you simply asking if there is anything to be concerned about when installed a default (non named) instance on...

phoenixrising1599 (6/12/2008)

---

Are there any performance / configuration issues with installing a default instance after installing a named instance on SQL2k5 64 bit standard on win2k3 64 bit platform?

I...

DBCC LOG(master,#)

# can be -1 through 4. Each brings back different data.

Anyways, run DBCC LOG(master,4) and look for something about 'dbdestroy'. Not sure you're going to find what you're...

To each their own ... but my favorite thus far: Server, Environment, Application, Number.

For example:

SDVDB1

Server - Development - Database - Number

SQAWEB1

Server - QA- Web - Number

SIPDB1

Server - Production - Database...

FreeHansje (6/10/2008)

---

Tnx for answreing, but:

Where is the object dbo.sysobjects? A unqualified select, or even a qualified select on this objects gives me a resultset, but I can't see it anywhere...

Completely dependent on your network and computer speeds ...

Can you connect via SSMS?

FreeHansje (6/9/2008)

---

On a SQL2005 I can see in MASTER a view sysobjects and a view system_objects. I can adress sysobjects with a select, but when I do the same with...

Yeah after watching it over the weekend I decided not to go with a single file for this particular reason, that and the times in which we do our file...