You create Microsoft Windows-based applications. You are changing an application to manage the daily activities of doctors and nurses in a hospital. The application will run on a single machine at the hospital front desk. The application will run 24 hours a day, seven days a week. Initial testing shows that the application consumes a lot of resources and that it runs out of memory intermittently. You want to change the application so that an alert is sent when memory usage is nearing the point of failure. An external application will be used for sending the alert. You need to decide what monitoring mechanism to use. You also need to ensure that the least amount of changes is introduced in the application. What should you do?

You create Microsoft Windows-based applications. You are creating a method. Your applications will call the method multiple times. You write the following lines of code for the method.

public string BuildSQL(string strFields, string strTable, string strFilterId) { string sqlInstruction = “SELECT “;
sqlInstruction += strFields;
sqlInstruction += ” FROM “;
sqlInstruction += strTable;
sqlInstruction += ” WHERE id =”;
sqlInstruction += strFilterid;
return sqlInstruction;
}

The method generates performance issues. You need to minimize the performance issues that the multiple string concatenations generate. What should you do?