Max utility parallel degree

Running ASE 15.7 at a high patch level? Say, 100 or higher? Having trouble running BCP, index creation, etc. in parallel? Here's why:

There's a new configuration parameter.

max util parallel degree specifies the server-wide maximum number of worker processes allowed per query used by the create index with consumers and update stats with consumers commands.

Enjoy!

New ASE content being added to Confio's site

Confio, a partner of ours with an awesome performance monotoring tool (call us if we can arrange a demo), has published extracts of several of our articles on their site... please go take a look!


http://www.confio.com/logicalread/results/?s=garbus

A bit too new to blogging....? How to ask me questions...

Hi, all,

Looks like I've had some comments sitting out there for a couple of years of which I was unaware... (I'm much better at database things...)

In the future, you're welcome to post here, but for a quick answer, email me directly, jeff@soaringeagle.biz.

Have a fantastic day!

Jeff

What's the plan of the process currently spinning out of control?

Sometimes you want to know what's going on NOW, not later after everything is done running. ASE 15 & later, you can run sp_showplan, which will get you that information while the spid is running.

sp_showplan spid, batch_id output, context_id output, stmt_num output

To display the showplan output for the current SQL statement without specifying the batch_id, context_id, or stmt_num:

sp_showplan spid, null, null, null

Space available on disk

select de.name, 'Size (meg)' = (high-low+1)/512, 'Used' =  sum(u.size)/256,         'Available (meg)'=  (high-low+1)/512 -  sum(u.size)/256 from sysdatabases da, sysusages u, sysdevices de where da.dbid = u.dbid and u.vdevno = de.vdevno and cntrltype = 0 group by de.name

Sometimes, I simply post these things here for my own convenience...

For ISUG members only...

Go to the members' site & take a look at my last two presentations:

Indexing for Performance

and

Join Performance

Free Database Tuneup

Hi,

We're offering a free, one-hour tuneup of your target database server. In order to take advantage, go to:

www.confio.com/sec

to download monitoring software, then email me (jeff@soaringeagle.biz) for a trial key, and we'll set it up.

No cost, no obligation, but we do find that most of the folks who take advantage fall in love with the tool or the service...

Enjoy,

Jeff Garbus