Category: General


This is an additional post on the perils of network performance, hardware, and file placement as related to Dynamics GP’s client/server processing algorithm.

While I could use posting, reporting, or data entry as an example, I will use SmartList as an example, since it provides a generic platform for non-technical analysis.

Let’s consider a simple action in Dynamics GP – the version is irrelevant for this scenario, other than the fact that SmartList was introduced in early versions of Great Plains Dynamics and CS+ and is commonly used.

  1. A normal system – our baseline:
    a. You request a Payables Transaction SmartList.
    b. The request is sent to the SQL Server Database Engine.
    c. Relevant data returns to the user’s temp folder in small packets (25 records each) for processing and temporary storage pending query completion.
    d. Results display to screen for further user interaction.
  2. A normal client with active antivirus scanning enabled
    a. You request a Payables Transaction SmartList
    b. The request is sent to the SQL Server Database Engine
    c. Relevant data returns
    d. Packet 1 – antivirus scans packet to ensure it is safe, then writes and stores in temp
    e. Packet 2 – antivirus engine scans packet
    f. Packet 3-400 (assuming default ‘first 1000 records’)
    g. Results display to screen
  3. A client with a low-bandwidth NIC (100Mb, Wireless)
    a. You request a Payables Transaction SmartList
    b. The request is sent to the SQL Server Database Engine
    c. Relevant data returns, but is unable to process as fast due to data backed up waiting its turn to get through. Think of the data as water, with the server 1GB+ NIC as a garden hose. With the 100MB NIC we are trying to force all the water passing through the garden hose into a drinking straw. Once the water is shut off (SQL processing finished), the hose will empty, but held back by the diameter of the straw.
    d. Packets arrive and results display on screen slowly

4. A client (or server) with slow disk drives or drives busy with other activities
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Query runs on server, writes to temporary tables, but both reading and writing data are slowed by the rate the server disks are able to read, write, and process the request. This is most noticeable in 5400RPM drives, but still noticeable in 7200RPM HDDs. If multiple databases are written to simultaneously, performance drops even more. That’s why data and log files, and tempdb should be on their own physical drives or drive arrays.
d. Relevant data returns, but is again hindered by a drive that cannot write fast enough to keep up with the data returned, or writing is hindered by the disk being busy writing other processes to disk, calculating spreadsheets, rendering drawings, etc.

5. Client with roaming profiles
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Relevant data returns to the temp folder on a different server
d. Client queries and processes data in the temp folder across the network. This will take many bundles of data, and we’re now shuffling data to another server.
e. Data returns to client and displays on screen for further processing

As you can see from the above examples, there are numerous ways in which data can be slowed down, backed up, or bottlenecked. Keep in mind that any combination of the above scenarios is also possible.

It’s also easy to alleviate many of these trouble spots.
In scenario #2, create Antivirus exceptions for known temporary files.
* In the %temp% folder:
* TNT*.dat
* TNT*.idx
* TNT*.tmp
* In a %temp%\TNT* subfolder:
* ASI*.dat
* ASI*.idx

In scenario #3, make sure the NIC is a minimum of 1GB, and any hubs (old) or switches support 1GB throughput. Most new computers already comply. If you’re connecting to your network on a wireless connection, plug in a network cable. If your notebook doesn’t have a NIC port, there are USB adapters.

In scenario #4, the faster the drive, the better the performance. A Solid-State Drive is fastest. Increased productivity will quickly offset the additional cost of an SSD.

In scenario #5, if your IT requires roaming profiles, make sure your network is as fast as possible, but ask if it’s available to store temp files locally rather than on another server.

Refugee Resettlement Watch

Especially so-called feminist women should listen!

Do not miss this interview of former refugee Mona Walter by Natalia Osten-Sacken at Gatestone Institute.

Mona Walter Mona Walter, the Swedish Ayaan Hirsi Ali

I’ve snipped just a bit of the interview, but the entire discussion is riveting.  See what she says about the moral equivalency the Pope has been promoting!

View original post 570 more words

PC Confusion

Today’s world is a confused and confusing mess.  I don’t want to be ‘woke’ – I’m already very much awake, thank you.

The following observations are from reality, not from dreams or some utopian fantasy.

  1. There are two (2) sexes – Male and Female – got it?  Biological fact.  Men’s facilities are for males, women’s facilities are for female.  Thinking there are nine (or however many you dream up) are in your head.  Wrong thinking.  We’d have a lot fewer problems if people would accept this reality.  Gender-fluidity is wrong thinking and born from deranged minds of the sort they used to lock in rubber rooms for the benefit of normal people.  Today they’re either courted by the media, part of the media, courted by politicians, or they are politicians.
  2. Today’s #MeToo frenzy confuses me.  It started out as a good thing.  I don’t condone rape in any way, shape, or form, and anyone that sexually assaults another should be punished.  But…  It’s gone too far.  Now we have women (or men) coming forward to say “[name goes here] touched my arm when we were at a restaurant in 1986, and I didn’t ask for it, so [name goes here] should be ashamed of themselves, and publically shamed as well.  You know what?  If you don’t want to be touched or, heaven forbid, hugged, don’t step out in public.  Ever.  Oh, yes, ladies, if you don’t want to be treated like a sexual object, don’t dress like one.  As in my first point above, men are biologically attracted to females, and the more you flaunt and tease, the more they’ll want.
  3. Christianity vs Islam – oil and water don’t mix.  No, certainly not all Muslims are terrorists, but their beliefs are not compatible with Christian beliefs and social structure.  The Pope is wrong.  I’m not Roman Catholic, but I know a Socialist when I see and hear one.  Holy Wars were fought in the name of eradicating the cancer known as Islam, but the Pope wants his sheep to hug it out with them instead.  Islam’s creed?  Fight the infidel until there are none left.  When the only people left are Muslim, then there will be the peace their religion claims.  No way.
  4. Racism.  God made us in many shades, all of them beautiful.  Be nice to me, I’ll be nice to you.  The end.  There is no White Supremacy.  If there was, we’d have NAAWP, a Congressional White Caucus, and White Lives Matter.  You know what?  We’re all human, let’s drop the color barriers.  Yes, I saw the evidence in Tennessee when I visited Nashville 50 years ago.  I was shocked then and can’t believe anyone ever saw a reason for it to continue beyond 1870.
  5. Celebrity culture.  Look, celebrities, no one cares what you think.  If we watch you or listen to you, it’s for your particular talent, not because you have something to say.  You’re super-rich, entitled, and want your lowly public to hang on your every word.  We don’t.  Act, or sing, and leave it at that.
  6. Pro Sports.  Same as other celebrities.  We don’t care what your causes are, we watch you because of your sports prowess.  Disrespect my flag, you’re dung.  My wish is that they would shut down the NFL and let players actually work for a living.  Play sports at night or on weekends, but you aren’t worth the millions you are paid.

Just sayin…

 

I have a perfect answer for the children protesting gun rights. After checking several sources, it seems there is an average of 11 teenagers killed each day by other teenagers texting or talking and driving. Taking these children’s logic to a relatively logical step forward, we just take away all cell phones and their cars! Phones and cars are killers and these children should not be allowed to apply for the use of one until they’re at a responsible age.  There are far more deaths by phone than guns any day of the year.

Let’s take this one more logical step.  Eleven deaths a day doesn’t include the number of suicides every year caused by shaming and bullying, much of it texted or messaged on these over-entitled children’s phones. Given that, it makes sense to take phones away until they’re old enough to respect the power in their hands.

Kids might actually have to interact with those around them face-to-face.  Without phones, they’d have time for homework, sports, and time with their families.  Compare that to what I see every day – kids from grade school through high school walking to and from the bus with shoulders slumped, staring down at their phones as they text ignoring the world and even those around them, not to mention the vehicles swerving to avoid them as they cluelessly wander down the middle of the street in a chatroom fog.

Helicopter parents worried about where their children are don’t need to give them phones.  A simple GPS tracker will suffice to locate them at school and around the neighborhood if you feel the need, or even better – old-fashioned parenting and trust when deserved.  Yes, you read correctly.  When. Deserved.  Not because they whine, cry and throw tantrums – when. deserved. period.

Let’s get these instruments of destruction out of our children’s hands!

Just sayin…

Pro Team Sports?

Another year, same old same old… A ‘team’ sports event is not the place for personal statements. Act as a team or get out!

RayNetCom

I’m not much of a team sports watcher, but we here in the USA have taken ‘pro’ sports to the extreme.  When I was attending Pirates ‘knothole’ games, an average baseball player salary was somewhere around $10,000 per year.  In the time it’s taken the minimum wage to go from $1.80 to $7.25 per hour, team sports ‘pro’ compensation has gone from that $10,000/yr figure to an average of $2,000,000 + /yr.

Team sports isn’t about the teams anymore, but about the players, their lifestyles, their endorsements.  We have so lost the idea of ‘team sports’ that players don’t feel the need to play as a team, but to outperform, outclass, do anything to NOT be a team member.

Today’s ‘pro’ is idolized, worshiped, revered – for what?  For the most part, the more lavish and outlandish your lifestyle, the more you align yourself with thugs and infamy, the more…

View original post 156 more words

What’s news?

I believe in free press. The news media has not only a right, but a duty to report the facts. Big word there, ‘facts’. Not spin, not opinion, but facts. CNN, NBC, CBS, yes, even FOX, are guilty of slanting news to their particular political philosophy. Today’s news is NOT news – it’s opinion, it’s editorializing. News reporting is supposed to be “Today this happened”, not having 10 people give you their opinion of why it happened. If you have not seen the movie ‘V for Vendetta’, play close attention to the media’s machinations. It’s identical to what we’ve come to accept as ‘news’ at this time. Fifty, sixty years ago, editorials occupied one, maybe two pages of the newspaper. The rest of the news section was just that, unspun, non-politicized facts.  Now you can’t find facts between the opinions – and that’s the front page.

News media, please give me facts and let me make up my own mind.

Just sayin’…

Benefit of the Doubt

It’s less than 2 weeks before election day, and it’s apparent that the scandals of HRC have no effect on Obama’s sheep.  I watched a news clip with a couple of early voters in Florida, and their comments were that they knew she was not perfect, she’d ‘made a mistake’, but she deserved another chance and benefit of the doubt.  Really?

One mistake, certainly.  Candidates are not perfect, they’re human, and if anyone votes for a candidate because of his or her purity, they’re insane.  Humans make mistakes, we’re not perfect, we’re not God.  Two mistakes and I’ve got a bit of serious thinking to do about their veracity and viability.  Two of the SAME mistakes or continued reckless behavior simply tells me they’re either incompetent or think that we the voters are stupid. Either way, they will not get my vote.

We as a country are headed in the wrong direction and need new leadership.  Being President does not mean having all the answers, but knowing who to ask and trust for the right answers.  With the Clintons, it’s who will give them the most money or power.  Their direction will head us further down the toilet bowl, and the handle has already been pulled.

We need someone to lift us out of there.  To finish with the toilet analogy, may the effects of their deeds speed their journey into the septic tank they deserve.

 

GP & SQL Compatibility

I replied to a GPUG question earlier today from someone wanting to use SQL 2016 with GP 2015.  It bears repeating here and applies to similar situations as well.

When Microsoft says not compatible, they mean it. It may work, but it’s not supported. If you do run into an issue with compatibility down the road, you have just burned all bridges, since you won’t likely be able to restore it later to a supported SQL version. At that point you can only hope that you’ve kept a copy of databases from the earlier SQL version and reenter everything from that point, or start over. It’s usually a deprecated function is specified in GP coding that will be the problem, and the only fix is to rewrite the software.

For years I was the “Damn the torpedoes, full speed ahead” guy, the one that could always trick the system into making it work after a client broke it, but after seeing the destruction and mayhem it can cause down the road (read potentially hundreds of consulting hours), it’s wise to trust Microsoft’s compatibility list. It’s there for a reason.

I’m Melting!

2 Chronicles 7:14 “if my people, who are called by my name, will humble themselves and pray and seek my face and turn from their wicked ways, then I will hear from heaven, and I will forgive their sin and will heal their land.” Read wicked ways = Clinton’s Socialist agenda.

A vote against Trump is a vote for an everlasting Socialist quagmire of greed, deception, and filth with no place for citizens. We become the Soylent Green that feeds the increasingly destructive engine of Democratic Socialism.

Clinton is sitting at the right hand of Satan, encourages murdering children, and encourages (as did her predecessor) confusion of the sexes. There is nothing good with or about her. I only hope that her end comes the night of November 8, 2016, and we as Dorothy in Oz hear ” You cursed brat! Look what you’ve done! I’m melting! melting! Oh, what a world! What a world! Who would have thought a good little girl like you could destroy my beautiful wickedness? Oooooh, look out! I’m going! Oooooh! Ooooooh! “


Who said I couldn’t quote the Bible and L. Frank Baum in one post?  … just sayin’

A Quiet Rage

A quiet rage is growing in this country against those who seek the crowning of Queen Hillary.  Morals and supposedly adult behavior are cast aside in the desperate need to up the ante in dirty politics.

It would seem that we the people have no say in these political amoral and immoral tactics other than to accept them.  The queen and her court of jesters and blind fools made up of pop stars and once-respected news media now await the predicted inevitable result of her majesty ascending the throne to grace her deplorable subjects with bread and water while she eats cake and drinks champagne.  It isn’t about what’s right, it’s about power.  She is the evil of all evils.  You think Obama was bad?  Just wait until HRC decrees the borders open and America fair game for control from external forces.  Power and control – that’s her objective.  She’s open to taking control of the UN as well, I’m sure.

The adoring media and their polls predict an easy win for her majesty.

Social media says differently.  I can only hope that on election day that those warriors with their pent-up rage emerge from behind their computers and cast their vote against the continuing rule of lies and corruption.

No, I’m not a fan of Trump, but I will vote for whoever has the best chance of defeating the sheer undisguised evil that is HRC.

If you haven’t seen the 2005 movie “V for Vendetta” please do so.  If you have seen it, treat yourself and watch it again.

Remember, remember the 8th of November…  Yeah, I know the date’s wrong, but it was too good to pass up.