Hello, everyone I'm a new DBA and I'm glad to join the forum. I have a few questions during my first serveral days of my work. What is the function of cliconfg.exe ? What is the benefit of the linkedServer? Regards, Robert
Welcome to the forum! Cliconfig.exe is used to configure client network protocols and client network libraries to tell clients how to connect to SQL Server. Linked Servers is a very broad topic. Maybe you should read the Books Online as an introduction to get the idea of Linked Servers?
Hi Frank, Thank you for your reply. BookOnline mentioned that linkedserver is used to deal with the distributed queries or remote calls. My company have serveral linked servers, which i heard my supervisor mentioned serveral times. But I still cannot get a rough idea of it. Why does the linked server exist ? How much it can help the database? I know the Cliconfig.exe now from your reply , but I saw this command is used to config Sql server alias, what's that for?
Welcome to the Forum If you want to access the objects exists on another server, one easy way is to use the Linked Server. Suppose the server names RS has a table called customers which resides in the database called Test and you want to access it, you can use SELECT columns FROM RS.Test.dbo.Customers You need to set RS as linked server using sp_addLinkedServer See BOL for more informations
Thank you ! From your examples, I now get a rough idea of a linkes server. As you say, it's a broad topic, so I may understand the mechanism during my work. We have a bad situation today. My supervisor told me that it happened once two years. The cpu usage on the server walks up to 100 , lasting for a long time. We know something is wrong with one of our procedures but we cannot optimize it. So,sleepless night! We are 2AM now...
