SQL Allocated Memory Alert Fix (From a Diva)

I typically like to keep my content on my site unique, but every once in a while, you get enough questions about a particular topic that's posted somewhere else, and you think "Dang! I wish I had that blog post here". Well, That's what I'm doing.

One of our MVPs, Susan Bradley, has an outstanding post on how to deal with SQL allocated memory alerts from SBS 2003.

That post is available here.

Susan's post gives step-by-step instructions for how to correct the MSSQL$SBSMONITORING service when it starts using too much memory, and your server starts sending you these:

---

Allocated Memory Alert on DOMAIN

A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems.

To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them.

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.

---

So if you're seeing this error, head on over to Susan's site, and get it resolved!

Thanks for a great post Susan!

---

In affiliate marketing, one can always save on cheap hosting in order to invest more on marketing. However, the domain name is not everything. The host should be compatible with the wireless internet service and should come with online backup free of charge.

---

Read More

Enabling the Network Map on Windows Server 2008

As you may have guessed, I've been running Windows Vista for quite some time now, I'm sure many of you have too, and are eagerly awaiting Windows Server 2008, and of course, utlimately, Windows Small Business Server 2008!

Well, looking at my Windows Vista Networking & Sharing Center, I was able to pull up the network map of my laptop (modified to fit this blog):


Wait a sec, where did you get that?

Ah, here's how I found this nifty feature:

• Click Start, then Network.


• Then right below the address-bar, you'll see Network and Sharing Center, click it


• Then above the graphic, click View Full Map, and there you have it

One of the things you'll notice immediately being on a Small Business Server 2008 box is that by default, this handy map is disabled. The reasoning for this is because as a Domain Controller, there could be many many machines attached to the network,and discoverying the layout of the network is not a task you really want your domain controller to be doing (you know, over allowing logons to happen, e-mail to be processed etc.). But it's not that big of a deal for small networks with some of the high powered machines you might have.

So here is how to turn it back on!

• Crack open your trusted local policy editor on the DC by clicking Start and running gpedit.msc, you'll have to accept the LUA prompt


• Browse down to Local Computer Policy, Computer Configuration, Administrative Templates, and Link-Layer Topology Discovery.


• Once in there switch both Turn on Mapper I/O (LLTDIO) Driver and the Turn on Responder (RSPNDR) driver to Enabled from Not Configured.


• Now refresh the map, you don't even need gpupdate /force because it's the local policy!

Enjoy the map view of your network.

Please note that some restrictions apply (as in XP machines without the LLTD responder installed will not reply, and any class of machine lower than Windows XP, including MAC and various forms of *ix)

---

Thanks to broadband, now affiliate marketing has new meanings. You can use cheap web hosting to host any kind of domain names you like, then you can proceed with website design and the rest. Features like online backup further contribute to the deal. One can compromise on the website design where needed.

---

Read More