Question: I have a pipe delimited text file I am using BULK INSERT to import into a table in SQL Server.

I have had real problems with certain characters. For example, text that appears in the text file as "30º of tilt and 80º" gets imported as "30┬║ of tilt and 80┬║"

Now, the data in the text file was actually generated from another SQL Server database, and in the original table the string appears as "30º of tilt and 80º" so I'm somewhat baffled.

Both databases have the same collation. The SP I use to do the bulk insert is:

```
DECLARE @sql nvarchar(4000) = 'BULK INSERT ' + @TempTable + ' FROM '''+@Sourcefile+''' WITH (FIELDTERMINATOR=''|'',ROWTERMINATOR=''\n'');'
EXEC(@sql)

```

Which works fine in all other respects

Thanks

Answer: 
If you think that AJAX monitoring and page load time will not help you, then
I can suggest that you can use Transaction monitoring. It can simply done by measuring time between two states or two pages. 

**To test locally, using `console.time`**:

```
  console.time('page_name'); 
  // Anything goes here
  console.timeEnd('page_name');

```

**Using `performance.now`**

```
 var start = window.performance.now();
 ...
 var end = window.performance.now();
 var time = end - start;

```

**Using [Atatus](https://www.atatus.com/) service**

If you are looking for service, you can try <https://www.atatus.com/> which helps you to measure between transactions in real time.

In atatus, you can measure between transactions or states by

```
 atatus.beginTransaction("page_name");
 ...
 atatus.endTransaction("page_name");

```
You can use a tool like Selenium to automate client behaviour and measure the response time.