Developer Newsgroups: SQL Server Tools

CPU-bound or I/O bound?

DWalker - 15 Sep 2007 8:34 PM - 6 messages

How do I find out if a given workload in SQL Server 2000 is CPU-Bound or I/O bound? How about in SQL 2005? Do I run a trace and process that? What do I look for? I'm just trying to decide if I should upgrade the motherboard and CPU of my ...

Re: SQL Profiler 2005

Valentijn - 15 Sep 2007 6:04 PM - 1 message

Hi, I voted as well. Furthermore I also have the diskspace problem when running a tuning session in the Database Tuning Advisor. I will try to see if the TEMP and TMP variables also apply to that tool! ...

can someone have idea on this perfmon result

fqiesbry - 15 Sep 2007 4:17 AM - 2 messages

I have setup perfmon counter in our DB server. some of the counters are Ave. disk read queue lenght, % processor time, batch request/sec and other counters. the interval is every 15 sec. I saw some entries that started some perf issue in our web-based application: ...

Shared SQL Server management

Terry - 14 Sep 2007 1:54 PM - 1 message

We have a shared sql environment, both 2000 and 2005 today. Our customers have direct 1433 access from the world. We want to eliminate this and at the same time provide a centralized web portal for them to manage their ...

Alter Table Property

Ryan - 13 Sep 2007 9:42 PM - 2 messages

I have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData folder. All client components are installed on my machine but do not have Management Studio. How do I ALTER a table property in this database either by using osql or ...

ANN: MS SQL Field Box 1.7

Andrew Popoff - 13 Sep 2007 11:48 AM - 1 message

I was angry. Again. And what was the reason? I use Query Analyzer. I had tried to find how correctly is written column name in the table, which is used in my SELECT query. And I wrote this utility. I named it "MS SQL Field Box" (FB). ...

SQL 2005 SP2 Restore Times Out

Bru - 12 Sep 2007 6:58 PM - 2 messages

Anyone else having issues restoring a DB in SQL 2005 SP2 from tape. All I get is a timeout error. This issue does not appear in SP1. I started with a working system where I could restore a DB. Upgraded only SQL 2005 to SP2 and ...

SQL Server Man Studio 2005 SP2 - Package failed to Load!

Stumped Steve - 12 Sep 2007 12:26 PM - 1 message

hi, I have uninstalled and installed to me heart content, but every time I start up SQL Server Management Studio 2005 SP2, I get the following error message "Package 'Microsoft SQL Management Studio Package' failed to" I then can't do anything in SQL Server Management Studio. I am only starting ...

Using maint plan to backup db to network drive

Ehren - 11 Sep 2007 7:28 PM - 2 messages

Hello- In setting up our system imaging software I wanted to move our database backup files off of the actual database system and move them to a data warehouse server. I would like to use the database maintenance plan to put ...

Don't see SQL Server Profiler

Andrew Witzel - 11 Sep 2007 3:52 PM - 2 messages

I am running SQL 2005 Workgroup Edition, have SP2 and all applicable updates and did a complete install off the CD's. I don't see SQL Server Profiler or Performance Tools for that matter off the Start-Programs menu. I also do not ...

Re: SQL Resources Monitor

Yashwant - 11 Sep 2007 1:17 PM - 1 message

Mark, You can use Profiler and/or Perfmon. They provide good enough information for perf related debugging. Yashwant ...

SQL Profiler 2000

Ron - 10 Sep 2007 9:08 PM - 3 messages

SQL2000 SP4 Does SQL2000 have a tuning advisor (like SQL2005) or anything comparable? I have a trace I'd like to analyze but it's a bear to go through. Thanks Ron ...

When DB maintenance is run, ie backup, is the DB taken offline?

Rick - 10 Sep 2007 7:46 PM - 4 messages

Can I run a DB every 2 hours during work hours without interrupting my users? Or does a backup need to run after hours in order to take itself offline? Sorry, cant find this info anywhere else. thanks for the help. ...

Using the Max_Errors parameter with the BCP utility

Nick - 10 Sep 2007 4:41 PM - 1 message

I am trying to use the BCP command to load data from text files into SQL Server 2005. In my scenario, if any of the data contains a syntax error, then I want no records added to the table in the database. ...

Space Required to store a file in database

apondu - 9 Sep 2007 6:55 PM - 2 messages

hi, I had a query on sql database, we know we usually store files of different type in sql database and its helpful for searching and retrieving the documents from the database, but one query i had was related to the amount of space required to store the files in the ...

SSMS Pain in the butt

Larry Killen - 9 Sep 2007 3:27 PM - 5 messages

At work, I use two monitors. I right click on a stored proc and slect execute and slide the execution window over to monitor 2 and run my stored proc.... I come home, open SSMS, right click on my stored proc and select execute and ...