Viewing 15 posts - 661 through 675 (of 1,155 total)
No, not required. But needs to do more work as its an alternative.
Abt OpenQueries Vs Linked Servers...
OPENROWSET and OPENDATASOURCE should be used only if you are accessing the remote OLEDB...
January 26, 2011 at 4:42 pm
Same thing here. But test well before applying on the prod box.
...
January 26, 2011 at 4:31 pm
Use Performance Dashboard Reports.
Thank You,
Best Regards,
SQLBuddy
January 26, 2011 at 4:01 pm
SSIS would be a good alternative.
But Linked Servers always have their place no matter what.
...
January 26, 2011 at 3:59 pm
Lack of technical knowledge, Lack of interpretational abilities, Lack of resources, Save time, money and effort, readymade monitoring alerts, Better functionality than perfmon.
...
January 26, 2011 at 3:57 pm
Elliott is Correct. Follow his advice.
But if you are bent on doing this for any special reason, then you can run a profiler trace, log the results into a SQL...
January 26, 2011 at 12:11 pm
Follow Gail's advice. She made a very good explanation.
...
January 21, 2011 at 9:28 pm
Grant is Right. Follow his recommendations.
Thank You,
Best Regards,
SQLBuddy
January 21, 2011 at 9:24 pm
This could most probably due to a scheduled bulk insert kind of jobs. Are you aware of any such kind of jobs running on the server ? Sometimes this could...
January 21, 2011 at 1:39 pm
Is the package stored on Sql Server or as file system package ?
If stored on SQL Server , the Job should run fine on both servers.
If stored as File system...
January 21, 2011 at 11:26 am
Yes you got them right. 🙂
Thank You,
Best Regards,
SQLBuddy
January 20, 2011 at 3:38 pm
Usually Min memory is not required. Maximum memory is the main setting required to be set. Also you need to consider the number of instances running on the cluster and...
January 20, 2011 at 3:25 pm
Follow Grant's and Gail's recommendations.
Also these counters should be a good list to begin with.
PhysicalDisk(_Total)\Avg. Disk Queue Length --(should get individual disks counters)
PhysicalDisk(_Total)\Avg. Disk sec/Read ...
January 20, 2011 at 2:12 pm
Custom logging means you specify a log file that will logs the events that happen in the SSIS package during its execution. If you already have one then it becomes...
January 20, 2011 at 1:43 pm
It copies only the job, not the package.
Actually what does the job do on Server B i.e Mirror Server ?
Was the Job on the Mirror able to run successfully in...
January 20, 2011 at 1:22 pm
Viewing 15 posts - 661 through 675 (of 1,155 total)