Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ovatvvon

    using PCIe x16 slots for two different devices?

    Awesome. Thanks! -Ovatvvon :-Q
  2. Ovatvvon

    using PCIe x16 slots for two different devices?

    Hi everyone, Quick question: If a motherboard, such as the "ASUS RAMPAGE FORMULA (x48)" has two PCIe x16 slots, and I want to use both slots, do they have to be two SLI video cards working together? Or, can I use one for a video card, and the other for a disk controller card to setup a RAID...
  3. Ovatvvon

    PERFMON - Percent Idle Time (disk)

    Ok. I have been using avg. sec/read & write all along. Microsoft recommended % idle time too, which is the only reason I included it, but it seems, like you said, worthless. Any idea what IO's / second should look like, both for DAS and SAN? (i.e. non-cached vs. cached, and I/O's per...
  4. Ovatvvon

    PERFMON - Percent Idle Time (disk)

    Hi Everyone, For anyone who's used PerfMon (at least on Windows 2003): I used it to collect performance data while users pounded the database. The results came back a bit funny for the % Idle Time counter though. In several cases, the MAX value for all counters was above 100%. In fact, it...
  5. Ovatvvon

    Database Snapshots - clarification quesetion

    I checked with DBA's for another client who used this solution. Apparently the deal is, if you have a database snapshot on the same server as the source database, it will forward the request through to the source database, except on those rows that have been changed, in which case it will ref...
  6. Ovatvvon

    Database Snapshots - clarification quesetion

    Hi Everyone, According to: http://msdn.microsoft.com/en-us/library/ms187054.aspx Database Snapshots in SQL 2005 do not provide a "true" separate database to read from, for reporting purposes. Instead, only initial updates at the page level will be stored in the snapshot, but the user will be...
  7. Ovatvvon

    Database Owner vs. DBO Permissions

    Hi, I realize this is probably a rather stupid question but: Are there any added permissions by assigning an account as a Database Owner (i.e. sp_changedbowner 'user account'), rather than simply giving it DBO permissions within a database? -Ovatvvon :-Q
  8. Ovatvvon

    Installing SSIS on Failover Cluster

    Jay is correct. I did not mean to give the impression that you cannot install on one side of a cluster. You can. :-) -Ovatvvon :-Q
  9. Ovatvvon

    Full Text Indexing Setup

    Hi, When enabling Full Text Indexing on a database in SQL 2005, you can easily enough click the checkbox in the database properties GUI. But if you want to specify where on the file-system you want the FT files to reside, where do you specify that? The only place I know of is in the files tab...
  10. Ovatvvon

    Installing SSIS on Failover Cluster

    I am not aware of the need to stop the cluster services yourself to install, although during the installation it may bring the cluster down once or twice. Also, just an FYI (in case you don't know), Integration Services is NOT cluster aware, so when your cluster fails over to the other node...
  11. Ovatvvon

    SQL 2008 - Change Data Capture - Merge question

    Hi all, We're trying to find a good solution to do incremental updates across databases. I was looking at the Change Data Capture feature in 2008, as well as Merge command for it. Does anyone know if this feature requires the two tables (source and destination) to be in the same database? Or...
  12. Ovatvvon

    Query with High CPU Cost

    This select query runs on our servers, and runs for a few days without ceasing, causing the CPU to run between 90%-100%. I ran an estimated execution plan against it, and 80% of the cost is from an Index Seek, and about 20% is from the sort. I did a rebuild on the Index, and updated the stats...
  13. Ovatvvon

    Change database permission

    Recycle SQL Server and make sure you get the first connection...(or wait for the existing connection to end). -Ovatvvon :-Q
  14. Ovatvvon

    Error message starting up SSMS Express

    CruiseMan, I would try going to Tools, then Options, as it suggests, and look for anything that may be referencing some settings, etc. If you can't figure it out there, worst case scenario is you could just uninstall/reinstall. It shouldn't take that long. Do you have the latest Service...
  15. Ovatvvon

    Change database permission

    Gate tec, Right click on the database (HRPERKDB), then select properties. When the dialog window opens, go to the OPTIONS tab along the top. Once there, in the first section, you will see two check boxes, Restrict Access and Read-Only. You're Restrict Access checkbox is checked with the...
  16. Ovatvvon

    How to forecast the size of a full text index?

    Anyone know any good rules of thumb for predicting how large a fulltext index will be on disk based on whatever the size of the database / column is? -Ovatvvon :-Q
  17. Ovatvvon

    Database User Can't Edit Their Own SQL Job

    It actually turns out there was an issue, somehow, with the user's Domain Login being lower case at one point, and upper case at another. We had our Microsoft Premier support guy look at it, and he's writing it up as a bug to Microsoft, so it can be fixed. (FYI: we have had SP2 for a long...
  18. Ovatvvon

    Database User Can't Edit Their Own SQL Job

    This is a global company, and there are dozens and dozens of databases on each shared server from various groups throughout the company. We cannot/will not give access to the clients on the box itself. That's for our DBA's and Server Admin's only. :-) -Ovatvvon :-Q
  19. Ovatvvon

    Database User Can't Edit Their Own SQL Job

    I'm uncertain as to the Active Directory setup, since I don't handle that area. This was also for another DBA who sits next to me, not actually my client; but as I understand it, she was able to get it to work by removing the highest level from them. They had SQLAgent Operator Role enabled for...
  20. Ovatvvon

    SQL Server 2005 security question

    Ya know, I was just thinking...this is silly. If they're admin's on the box, they should be trustworthy. If they're not trustworthy, they shouldn't be admin's. Am I thinking about this wrong here? -Ovatvvon :-Q

Part and Inventory Search

Back
Top