Here is the question: how can you determine how many and what cross-database queries are running on your server? . . . → Read More: Question of the week: how do you find cross-database queries?
|
|||||
|
When I try to analyze a query in the DTA by right-clicking a tab in the Management Studio I get the following error: Failed to connect to an IPC Port: The system cannot find the file specified. Solution: What I did to fix the error is to start the task manager and kill the DTASHELL.exe proces. linkscolor . . . → Read More: DTA would not start Here is a script which is used to move the current location of the tempdb files. You would need to move the tempdb files either to get better performance, or to deal with size issues. Or both. After you run the following script, you will need to restart the SQL Server service. ?View Code TSQLUSE master As you know, msdb is home of quite a few SQL Server features, and one of them is the DTA tables, procedures and functions. Every time you run the Database Tuning Adviser, it generates some data which is stored in the msdb DTA_* tables. There is no way, however to clean up after the DTA. Here is . . . → Read More: DTA – what is making my msdb grow? I have been getting the following error related to the replication: Message This message is related to the following: when you set up replication, there is a . . . → Read More: SQL Server replication – distribution folder not cleaned up  |
 |
||||
|
Copyright © 2010 Feodor Georgiev's blog - All Rights Reserved |
|||||
|
|
|||||
