3/12/2023 0 Comments Sql connection stringIn the sys.dm_exec_sessions management view output below, notice how much more informative the last row is because it contains a meaningful program name. True, these defaults indicate the technology that that program was built using-but the DBA can find this information elsewhere, as his management views separately report the client interface library used by the session. These default values aren’t particularly helpful to the DBA, as they don’t reveal the identity of the program using the session. Out of the box, SqlConnection defaults this name to “.Net SqlClient Data Provider” on. This name, passed from client to Microsoft SQL Server when a connection is established, can be used by the DBA to differentiate between multiple applications running on a single client and to focus on (or filter out) activity from the same application across multiple clients.ĭoes your application pass a meaningful program name to the database server? One clue is the name of the client program associated with each database session. You’d want all the clues you can get to help you figure out what’s going on. Imagine you’re a database administrator tracing query activity on a server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |