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
Wednesday, September 18, 2013
Wednesday, April 17, 2013
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
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
Thursday, April 4, 2013
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.
To display the showplan output for the current SQL statement without specifying the batch_id, context_id, or stmt_num:
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
Tuesday, October 16, 2012
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...
Thursday, August 30, 2012
For ISUG members only...
Go to the members' site & take a look at my last two presentations:
Indexing for Performance
and
Join Performance
Indexing for Performance
and
Join Performance
Wednesday, July 25, 2012
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
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
Tuesday, June 26, 2012
Index talk for ISUG on June 27th
Go to ISUG.com and register... tomorrow is my webinar on indexing.
*Everything You Wanted to Know About Indexing for Performance.*
Wednesday, June 27th, 1pm-2:30pm.
*Please note that this is a 90 minute session.*
*Synopsis*
This session will cover everything you want to know about indexes but
didn’t know who to ask. Topics include:
- Differences between clustered & nonclustered indexes, and why you’d
choose one over the other
- Why the optimizer will or won’t select an index
- The difference between an index and a key
- Using and abusing search arguments (SARGs)
- Index covering
- Forcing index selection (and why you don’t’ want to)
- Partition support (time permitting)
Register now: http://my.isug.com/e/in?eid=145
*About the Speaker*
Jeff’s background includes a B.S. Degree from Rensselaer Polytechnic
Institute, and work experience from PC's to Mainframes and back again. Jeff
has many years of client/server, Sybase, and Microsoft SQL Server
experience, with a special emphasis on assisting clients in migrating from
existing systems to pilot and large-scale projects with very large
databases. He is very well known in the industry, having spoken at user
conferences and user groups for many years, written articles and columns
for many magazines nationally and internationally, as well as having
written over a dozen books. Recently his focus has been on database
performance, tuning, monitoring, and reengineering. Jeff has been in
consulting, training, and the software businesses for over 2 decades. He
has a demonstrated talent for staying at the leading edge of technology, as
well as transferring his knowledge to others.
*Note that attendance is free for Basic, Green or Gold members only.
Non-members and associate members must either join/upgrade, or pay a small
fee to attend. To help make this decision easier for you, in August Jeff
will be back with a second session on query joins. We anticipate Jeff
presenting every couple of months or so after that, so now is a great time
to become a full member.*
*Everything You Wanted to Know About Indexing for Performance.*
Wednesday, June 27th, 1pm-2:30pm.
*Please note that this is a 90 minute session.*
*Synopsis*
This session will cover everything you want to know about indexes but
didn’t know who to ask. Topics include:
- Differences between clustered & nonclustered indexes, and why you’d
choose one over the other
- Why the optimizer will or won’t select an index
- The difference between an index and a key
- Using and abusing search arguments (SARGs)
- Index covering
- Forcing index selection (and why you don’t’ want to)
- Partition support (time permitting)
Register now: http://my.isug.com/e/in?eid=145
*About the Speaker*
Jeff’s background includes a B.S. Degree from Rensselaer Polytechnic
Institute, and work experience from PC's to Mainframes and back again. Jeff
has many years of client/server, Sybase, and Microsoft SQL Server
experience, with a special emphasis on assisting clients in migrating from
existing systems to pilot and large-scale projects with very large
databases. He is very well known in the industry, having spoken at user
conferences and user groups for many years, written articles and columns
for many magazines nationally and internationally, as well as having
written over a dozen books. Recently his focus has been on database
performance, tuning, monitoring, and reengineering. Jeff has been in
consulting, training, and the software businesses for over 2 decades. He
has a demonstrated talent for staying at the leading edge of technology, as
well as transferring his knowledge to others.
*Note that attendance is free for Basic, Green or Gold members only.
Non-members and associate members must either join/upgrade, or pay a small
fee to attend. To help make this decision easier for you, in August Jeff
will be back with a second session on query joins. We anticipate Jeff
presenting every couple of months or so after that, so now is a great time
to become a full member.*
Subscribe to:
Posts (Atom)
