Restarting a Windows Server from another NetQoS server

Sometimes when you restart a server, it hangs and doesn't restart. This means that the RDP sessions fails but you can ping the box.

Use the shutdown -i command from the command line of another server. Fill out the GUI to force a restart.

You can also run the following from command line:

shutdown /r /m \\servername

Where servername is either an ip address or the dns name of the server.

NV database repair (BI)

Completed successfully on 11/27/2012

 

NV database repair:

show databases

use nms2

repair table pollinst use_frm; <enter>

repair table group_instances use_frm; <enter>

nqwebtool -verbose

nqwebtool -verbose

Free Up Space on the C Drive

***PUBLIC INFORMATION - THIS CAN BE SHARED WITH CUSTOMERS AS NEEDED***

ISSUE

How do I free up some space when the C:/ drive is near full?

RESOLUTION

The simplest thing to do to free up some space on the C:/ drive is to run the NQDiskCleaner utility. Just download the tool and run it anywhere on the server. It will remove any unnecessary and temporary files.
ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/nqdiskcleaner.zip (see options below)

Use windirstat to find out what is taking the most space. http://sourceforge.net/projects/windirstat/.
That will show disk usage in a visual way where you can see what is taking up the most space. Look at C:, and see if you can clean up some disk space.

If this doesn't free up enough space, you can move the page file over to the D:/ drive. To do this, just follow these steps:

1. Right click on My Computer -> Properties
2. Select Advanced tab.
3. Click Settings in the Performance section.
4. Select Advanced tab.
5. Click Change in the Virtual memory section.
6. Note the values under 'Initial size (MB):' and 'Maximum size (MB):'
7. Select the D: drive. Select 'Custom size:'
8. Change the values to match the ones noted in step 6.
9. Click 'Set'
10. Select the C: drive.
11. Select 'No paging file'
12. Click 'Set'
13. Click 'OK' three times.
14. Select Yes to Reboot the server.

You could also try moving the windows temp folders to the D:\ drive, where there is usually more space.

1. Right click on My Computer and select Properties.
2. Click on the Advanced Tab.
3. Click on the Environment Variables button at the bottom.
4. In the bottom section of the window (System Variables), scroll down to the bottom where TEMP and TMP are.
5. For both TEMP and TMP, left-click on the variable name, then click "Edit".
6. Change the variable value from "%SystemRoot%\TEMP" to "D:\netqos\temp".
7. Click ok, then repeat the procedure so both TEMP and TMP are set to the new directory.
8. Create the D:\netqos\temp directory if it does not already exist.
9. Restart the server.

NOTE: After the reboot, you can delete the C:\Windows\temp directory to free up disk space on C:\.

Another thing that can be done is to clean up the web service logs, if they are enabled, in C:\WINDOWS\system32\LogFiles\W3SVC1.
You can disable them by going into IIS manager and right click the Websites folder and select properties, and uncheck the Enable Logging box. Then reset IIS in cmd: iisreset.

NQ Disk Cleaner

-Deletes hidden folders in C:\windows. Typically these are backup files from Windows Updates containing files replaced by specific Windows OS patches.
-Runs Windows Disk Cleanup. It enables all options, including hidden options within the tool then runs the tool to delete files.

Options enabled:
 Recycle Bin
Content Indexer Cleaner
Downloaded Program Files
Internet Cache Files
Memory Dump Files
Microsoft Event Reporting
Offline Files
Offline Page Files
Old ChkDsk Files
Remote Desktop Cache Files
Setup Log Files
Temporary Files
Temporary Offline Files
WebClient and WebPublisher Cache
Active Setup temp folders
Compress old files

-Deletes IIS logs in c:\windows\system32\LogFiles\W3SVC\ or c:\winnt\system32\LogFiles\W3SVC\
-Empties the Recycle Bin

NetFlow Configurations

Subject: NetFlow Configurations
From: Webb, Rob
To: TEAM - SABU - NETQOS - TECHNOLOGY
Date Sent: 10/4/2011 10:59:48 AM

I recently answered a question about what’s the best way to configured flow data on a router.  Here is what I’ve found through my experience.  Thought I’d share with the entire team:

There are several options for configuring NetFlow:

1)      Ingress only (default):  this must be applied to ALL active L-3 interfaces in order to properly calculate the outbound on any give interface.  This is because netflow is being collected inbound to the router and in order to calculate the outbound all traffic destined out a particular interface is associated with the outbound metric for that interface.  The limitation is when you have a router marking QoS, the marking occurs after the NetFlow is calculated.  Works with v5 or v9

2)      Egress only:  works the same as Ingress but in the opposite direction.  The advantage is now the NetFlow is being calculated after the QoS marking…and therefore you will see how the traffic is marked as it leaves a given router.  Again, ALL active L-3 interfaces need to have this configured in order to provide accurate inbound measurements. Works with v5 or v9

3)      Ingress & Egress:  This works with NetFlow v9 (IOS 12.4 and newer).  Yes, there is an increase in flow data, however now only the interface(s) of interest need the flow commands.  If flow data is collected at multiple points (i.e. inbound on one interface and again as outbound on another) the v9 flows contain a marker that identifies the interface and direction.  RA is intelligent enough to only count the most relevant data not eliminate double counting of this traffic.  Works with v9 only.

In summary:

Ingress = on all active L-3 interfaces / not good if marking (QoS) in the same router as reporting

Egress = on all active L-3 interfaces / good if marking (QoS) in the same router as reporting

Ingress/Egress = best option, only configured on interfaces of interest

Do not mix and match.  Pick one and stick with it on any given router!

_________________________________________________________________________

ca  Technologies | Rob Webb | Senior Principal Consultant, NA Solutions Architecture Group | 412-916-8023 | rob.webb@ca.com

One additional point I'd like to add is that RA will double count flows if ingress AND egress is enabled on the LAN and WAN interfaces AND using NetFlow version 5.

Export discovery scopes? SQL

There’s nothing built-in to the product to support this, you have to do it through sql.

You could use this query, and then copy the output into a text file:

select concat(scope_net,',',scope_mask) from discovery_scope where scope_includes=1;

it’ll only grab the included scopes, not the excluded ones. 

Alex

Recreate SA database

Hello Rob,

I can't get any of the repair functions to pick this up either. What I would like you to do now is make a backup of the database by making a copy of D:\netqos\mysql51\data\super in another location. After that, I would like you to connect to mysql via mysql -P3308 super and then run the following command:

drop table runs2;

If this fails don't worry about it as it may not be able to see the table anyway. After this, please run the following to recreate the table:

CREATE TABLE `runs2` (

  `PROBE_ID` int(10) unsigned NOT NULL DEFAULT '0',

  `FEED_INDEX` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `SOURCE_ID` smallint(5) unsigned NOT NULL DEFAULT '0',

  `APP_ID` int(10) unsigned NOT NULL DEFAULT '0',

  `SERVER_ID` int(10) unsigned NOT NULL DEFAULT '0',

  `TIME_END` int(11) NOT NULL DEFAULT '0',

  `CLIENT_ADDRESS` int(10) unsigned NOT NULL DEFAULT '0',

  `CLIENT_MASK` int(10) unsigned NOT NULL DEFAULT '0',

  `CLIENT_ID` int(10) unsigned NOT NULL DEFAULT '0',

  `DET_CLASS` int(10) unsigned NOT NULL DEFAULT '0',

  `DET_MASK` int(10) unsigned NOT NULL DEFAULT '0',

  `DETAIL1` int(10) unsigned DEFAULT NULL,

  `DETAIL2` int(10) unsigned DEFAULT NULL,

  `DETAIL3` int(10) unsigned DEFAULT NULL,

  `DETAIL4` int(10) unsigned DEFAULT NULL,

  `DETAIL5` int(10) unsigned DEFAULT NULL,

  `DETAIL6` int(10) unsigned DEFAULT NULL,

  `DETAIL7` int(10) unsigned DEFAULT NULL,

  `DETAIL8` int(10) unsigned DEFAULT NULL,

  `APP1_COUNT` float NOT NULL DEFAULT '0',

  `APP1_SUM` float NOT NULL DEFAULT '0',

  `APP2_COUNT` float NOT NULL DEFAULT '0',

  `APP2_SUM` float NOT NULL DEFAULT '0',

  `APP3_COUNT` float NOT NULL DEFAULT '0',

  `APP3_SUM` float NOT NULL DEFAULT '0',

  `APP4_COUNT` float NOT NULL DEFAULT '0',

  `APP4_SUM` float NOT NULL DEFAULT '0',

  `APP5_COUNT` float NOT NULL DEFAULT '0',

  `APP5_SUM` float NOT NULL DEFAULT '0',

  `APP6_COUNT` float NOT NULL DEFAULT '0',

  `APP6_SUM` float NOT NULL DEFAULT '0',

  `APP7_COUNT` float NOT NULL DEFAULT '0',

  `APP7_SUM` float NOT NULL DEFAULT '0',

  `APP8_COUNT` float NOT NULL DEFAULT '0',

  `APP8_SUM` float NOT NULL DEFAULT '0',

  `APP9_COUNT` float NOT NULL DEFAULT '0',

  `APP9_SUM` float NOT NULL DEFAULT '0',

  `APP10_COUNT` float NOT NULL DEFAULT '0',

  `APP10_SUM` float NOT NULL DEFAULT '0',

  `APP11_COUNT` float NOT NULL DEFAULT '0',

  `APP11_SUM` float NOT NULL DEFAULT '0',

  `MAINTENANCE` int(11) NOT NULL DEFAULT '0',

  KEY `TIME_END` (`TIME_END`),

  KEY `APP` (`APP_ID`,`TIME_END`),

  KEY `SERVER` (`SERVER_ID`,`TIME_END`),

  KEY `CLIENTS` (`CLIENT_ADDRESS`,`TIME_END`),

  KEY `CLIENT_ID` (`CLIENT_ID`,`TIME_END`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

/*!50100 PARTITION BY RANGE (time_end)

(PARTITION p20120823_12h17m37 VALUES LESS THAN (1345738657) ENGINE = MyISAM,  PARTITION p20120826_02h17m37 VALUES LESS THAN (1345961857) ENGINE = MyISAM,  PARTITION p20120828_16h17m37 VALUES LESS THAN (1346185057) ENGINE = MyISAM,  PARTITION p20120831_06h17m37 VALUES LESS THAN (1346408257) ENGINE = MyISAM,  PARTITION p20120902_20h17m37 VALUES LESS THAN (1346631457) ENGINE = MyISAM,  PARTITION p20120905_10h17m37 VALUES LESS THAN (1346854657) ENGINE = MyISAM,  PARTITION p20120908_00h17m37 VALUES LESS THAN (1347077857) ENGINE = MyISAM,  PARTITION p20120910_14h17m37 VALUES LESS THAN (1347301057) ENGINE = MyISAM,  PARTITION p20120913_04h17m37 VALUES LESS THAN (1347524257) ENGINE = MyISAM,  PARTITION p20120915_18h17m37 VALUES LESS THAN (1347747457) ENGINE = MyISAM,  PARTITION p20120918_08h17m37 VALUES LESS THAN (1347970657) ENGINE = MyISAM,  PARTITION p20120920_22h17m37 VALUES LESS THAN (1348193857) ENGINE = MyISAM,  PARTITION pMaxValues VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */;

/*!40101 SET character_set_client = @saved_cs_client */;

This should generate the new table for you with the needed configuration.

Please let me know if this takes care of the issue. Please let me know if there is anything else that we can assist you with in the meantime.