Just found and downloaded. Highly recommended.
http://www.mythicsoft.com/page.aspx?page=download&type=agentransack
Thursday, October 18, 2012
Thursday, October 11, 2012
Trace SQL Server using Scripting and No Client for Better Performance
There is a very good article on creating server side traces in SQL Server here:
SQL Server Pedia - Server Side Traces
The essence of the whole thing is this:
Monitoring using the SQL Server Profiler creates considerable overhead, whether you run it on the server that hosts the database itself, or on a client machine.
Monitoring using a script of the sort generated in the linked article, on the other hand, creates nearly zero performance degradation (per Linchi Shea's fine article, found here: trace-profiler-test). I have linked to Linchi's test results as well as the article. Test Results
SQL Server Pedia - Server Side Traces
The essence of the whole thing is this:
Monitoring using the SQL Server Profiler creates considerable overhead, whether you run it on the server that hosts the database itself, or on a client machine.
Monitoring using a script of the sort generated in the linked article, on the other hand, creates nearly zero performance degradation (per Linchi Shea's fine article, found here: trace-profiler-test). I have linked to Linchi's test results as well as the article. Test Results
Wednesday, September 26, 2012
RDP Scrollbars
Speaking of RDP:
I want to set my RDP session to be less wide than my monitor screen, but every bit as high.
This is an issue, because RDP wants to add the control area (minimize, maximize, etc) and leaves you with a scrollbar.
I got rid of this with the help of the article found here: http://manojtesting.blogspot.com/2011/11/pesky-scrollbars-on-remote-desktop.html
The answer is to add the following line to your default.rdp file, which you can edit with any text editor.
smart sizing:i:1
Fantastic :-)
EDIT: In Windows 10, I seem to have trouble finding default, RDP.
As noted here, the default location is %My Documents%\Default.rdp.
I want to set my RDP session to be less wide than my monitor screen, but every bit as high.
This is an issue, because RDP wants to add the control area (minimize, maximize, etc) and leaves you with a scrollbar.
I got rid of this with the help of the article found here: http://manojtesting.blogspot.com/2011/11/pesky-scrollbars-on-remote-desktop.html
The answer is to add the following line to your default.rdp file, which you can edit with any text editor.
smart sizing:i:1
Fantastic :-)
EDIT: In Windows 10, I seem to have trouble finding default, RDP.
As noted here, the default location is %My Documents%\Default.rdp.
RDP Shortcut keys
Boy, these have made my life as a sysadmin a lot easier. No longer need to have an RDP session in full-screen to do alt-tab etc. Fantastic. The ctrl-alt-minus + plus require you to use the +/- on the numeric keypad to create a local screenshot in the clipboard on the server.
A commenter also says CTRL+ALT+MINUS is equivalent to ALT+PRTSCRN, and CTRL+ALT+PLUS = PRINTSCRN.
http://msdn.microsoft.com/en-us/library/windows/desktop/aa383500(v=vs.85).aspx
A commenter also says CTRL+ALT+MINUS is equivalent to ALT+PRTSCRN, and CTRL+ALT+PLUS = PRINTSCRN.
http://msdn.microsoft.com/en-us/library/windows/desktop/aa383500(v=vs.85).aspx
Sunday, September 23, 2012
Church
Church spins me about.
It fogs things up.
It muddles my mind.
Some guy goes up in front of me, setting himself as the
representative of the God I love and the Christ to which I try to make myself a
disciple. He gathers all the trappings
of power and authority, ranging from an American flag to a stage and a big podium
and a cross and a bible and a business suite,
and then he proclaims things with which I would vociferously disagree, based,
actually, on my faith and interpretation of the teachings of Christ.
This puts me in an untenable position. Do I resist this man who is trying to
exercise this power over me, and in doing so resist what, in some powerful part
of my feeble mind, is still the representative of Christ, or do I succumb to his
teachings and, in doing so, abandon my own carefully studied, deeply held
beliefs, that I’ve worked out with no small amount of prayer, fasting, sleepless
nights, fear and trembling.
I won’t be put in that position.
My mind is my own. My
faith is my own. I can read, I can think critically. I can approach almighty God, having been gifted
at birth with everything I need to do so.
Friday, August 31, 2012
You didn't build that
I know a lot of smart, hard working people who aren't rich. I know rich people who are lazy as the days is long. Rich people aren't rich because they're smart and hard-working. They're rich because they found a way to get rich. Many times it's because of connections, who they know, or access that they have. I know rich people who aren't very bright at all. I know poor people who are smart and work really hard, but don't find money to be the most important thing in their lives, or chose a vocation that isn't well compensated by our free markets, like nursing.
I'm no Billionaire, but I've had some success in my life. I've put in a lot of weekends and late nights and 15 hour days and gone to bed for months at a time with chest-pains to get it. At the risk of sounding like douche, I've got an IQ that I'd put up against about anybody's. And yet, I'm not rich. How does that work?
And, even for the success I've had, I have to credit much of that success to people who cared about me: great family and public schools with teachers who invested of themselves in my success and access to higher education, and great people who inspired me. Yes, it's true - I've worked REALLY hard for whatever success I've had. But THAT's only one factor in the equation.
"Somebody helped to create this unbelievable american system that we have that allowed you to thrive.
Somebody invested in roads and bridges. If you've got a business, you didn't build that. Somebody else made that happen."
I wish our normally eloquent and articulate POTUSA had said "you didn't build those roads and bridges on which your business relies". In context, it's quite clear THAT THAT's what he meant by THAT "THAT".
http://youtu.be/YKjPI6no5ng
Tuesday, August 07, 2012
Auto Starting WebSphere Network Deployment V8 on AIX
We have very basic AIX, with no bells or whistles installed.
To create a launch script, the startmanager, startserver, and starnode scripts will generate this for you. The command is
.. as appropriate...
In my case, I'm going to auto-start the deployment manager and the node agent, and then use the WAS monitoring policy to handle the individual app servers.
So, the steps are:
To create a launch script, the startmanager, startserver, and starnode scripts will generate this for you. The command is
./startManager.sh -script -backgroundor
./startNode.sh -script -backgroundor
./startServer.sh-script -background
.. as appropriate...
In my case, I'm going to auto-start the deployment manager and the node agent, and then use the WAS monitoring policy to handle the individual app servers.
So, the steps are:
- Generate the startup scripts using the above commands.
- make a copy of rc.was (found in the was bin directory) for the deployment manager, and another for the node agent. I called these rc.dm.was and rc.na.was.
- Edit these to point to the start_dmgr.sh and start_nodeagent.sh scripts generated above
- create entry in etc/Inittab for the two files created in step 2
- was:2:once:/usr/WebSphere/AppServer/bin/rc.dm.was >/dev/console 2>&1
- was:2:once:/usr/WebSphere/AppServer/bin/rc.na.was >/dev/console 2>&1
And, that should do it. Let's see if it works :-)
Subscribe to:
Posts (Atom)
Get Restart log using PowerShell
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...