Missing table in SqlNexus database tbl_PERF_STATS_SCRIPT_RUNTIMES

[seansensus]

I locally fixed the database connection strings in my previous reported issue and ran into this:

[nnerson]

Hello,

I faced a similar Issue. The problem was related to Collation. If the model database is not CI then you may need to manually create the database using those commands:

Use [master]
Go
Drop Database [sqlnexus]
Go
Create Database [sqlnexus]
Go
Alter Database [sqlnexus] Collate Latin1_General_CI_AI
Go

In this case, don't drop the current DB before importing.

I hope it is useful
Nicolas.

[mrittberg]

Hello,

I am also facing this problem, unfortunately, the workaround (new creation of the table) didn't work.

I am grateful for any help.

[seansensus]

Hi, I didn’t spend any time trying to figure this out, and moved on to using these tools: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit Enjoy! Sean From: mrittberg [mailto:notifications@github.com] Sent: Tuesday, July 24, 2018 12:13 AM To: Microsoft/SqlNexus <SqlNexus@noreply.github.com> Cc: Anaya, Sean <Sean.Anaya@xyleminc.com>; Author <author@noreply.github.com> Subject: Re: [Microsoft/SqlNexus] Missing table in SqlNexus database tbl_PERF_STATS_SCRIPT_RUNTIMES (#55) Hello, I am also facing this problem, unfortunately, the workaround (new creation of the table) didn't work. I am grateful for any help. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#55 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHYHrs8eLOAsHncoARLEf6_eSLswc_8Oks5uJrrOgaJpZM4QYiJ2>.

[gambit9009]

Double sided issue here.
#1. Check the table to make sure it exists before blindly doing a.
fmImport.cs line 1128

SqlNexus/sqlnexus/fmImport.cs

Line 1128 in 16016cb

cmd.CommandText = "select count (distinct runtime) 'NumberOfRuntimes' from tbl_PERF_STATS_SCRIPT_RUNTIMES";

cmd.CommandText = "select count (distinct runtime) 'NumberOfRuntimes' from tbl_PERF_STATS_SCRIPT_RUNTIMES";

#2. Why was the table not there? Looking in code can see how it is possible. We create that table from tbl_OS_WAIT_STATS without checking to see if that data is blank.

IF OBJECT_ID ('tbl_PERF_STATS_SCRIPT_RUNTIMES') IS NOT NULL DROP TABLE tbl_PERF_STATS_SCRIPT_RUNTIMES
GO
--it used to use tbl_requests. but that table wont' get much data if server is idel. wait stats is gauranteed to generate
SELECT DISTINCT runtime INTO tbl_PERF_STATS_SCRIPT_RUNTIMES FROM tbl_OS_WAIT_STATS ORDER BY runtime
GO

Worst case. Create blank table. Insert into it.