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: *

  • Users: vnad
  • Order by date
  1. vnad

    Unique by set - How to get resultset

    Let me try this again. I have the following table with the following data. Id1 Id2 Column1 1 2 A 1 2 B 1 2 C 1 3 A 1 3 B 1 3 C 1 4 A 1 4 D 1 4 E The data is unique by having the groups of data. So for Id1 = 1, there is two unique sets of data, A,B,C and...
  2. vnad

    Unique by set - How to get resultset

    So I have a problem that I don't think is too rare but having a brain fart. So I have multiple sets of data. Id1 Id2 Column1 1 2 A 1 2 B 1 2 C 1 3 A 1 3 B 1 3 C 1 4 A 1 4 D 1 4 E So I have a 1 unique set of id1=1 with A, B, C and another uniquie set of...
  3. vnad

    How do you check if full text change tracking is on?

    Found it SELECT OBJECTPROPERTY (<object_id>,'TableFulltextChangeTrackingOn') SELECT OBJECTPROPERTY (<object_id>,'TableFulltextBackgroundUpdateIndexOn') You can find the object ids from the sysobjects table. If the query returns a 1, that means it is on, a 0 means it is off.
  4. vnad

    SQL Server performance.

    I had a similar problem. Our data on server A was on a SAN and Server B had it on just a local raid array. Server B would be a lot quicker than server A. The issue turned out to be that they stripped the SAN incorrectly. Meaning, the partion had multiple strips on the same disks. So instead of...
  5. vnad

    How do you check if full text change tracking is on?

    I have a table and I want to see if full text change tracking is enabled? Where do you check this? Also, how would you check to see if auto propagation for the background update index is on as well?
  6. vnad

    Full text indexing / MSSEARCH - different server?

    Thanks for the quick reply. I was looking into a CPU issue when I noticed how much CPU the incremental populations were taking for resources. It jumps it to about 80-90 percent cpu when running and only 15-20 percent cpu when it is idle. Those are good ideas as I was thinking similar things...
  7. vnad

    Full text indexing / MSSEARCH - different server?

    Is it possible to move the MSSEARCH.EXE service off our production server to a 2nd (SQL) server so we can distribute the CPU and I/O of the incremental populations that are going on for the full text indexes? We are seeing high CPU usage and I/O from the loads we are doing throughout the day...
  8. vnad

    Symmetrix vs HP local disk (8 x 72gb 15k raid 5), HP winning

    They are stripped drives and I was told we do not share on the same physical disk. We are also using powerpath software so it is load balanced. Do you mean load balanced on the Sym?
  9. vnad

    Symmetrix vs HP local disk (8 x 72gb 15k raid 5), HP winning

    I am running some comparisons on a HP ML570 box. We have one 36gb (8GB luns, 0+1) drive on the company EMC Symmetrix attached by two emulex 9802 fibers with powerpath. We also have 400GB drive with 8 x 72gb 15k local attach scsi disks running a raid 5. When I run comparisons, the local attached...
  10. vnad

    Wscript hangs when running command

    You are my hero. I tried using the run command but did not know about the variables. Thanks.. works great now.
  11. vnad

    Wscript hangs when running command

    I am running a pretty simple command through VBscript Set oShell = CreateObject("Wscript.Shell") commandRun = "cmd /k WZZIP " & destinationFolderPath & sDate & " " & destinationFolderPath & "dn*" set OutputValue = oShell.Exec (commandRun) Do while (outputValue.Status <> 2) wscript.sleep(1000)...
  12. vnad

    Path not found - Virtual directorys / File system objects

    It works once I give IUSR permissions on the remote server to the directories I need to go after. I still have some questions though. What is the point of Virtual directories then if you can just put in the UNC path ie <% set oFso=Server.CreateObject("Scripting.FileSystemObject") For...
  13. vnad

    Path not found - Virtual directorys / File system objects

    I have the following code <BODY> The path of the virtual directory is <% Response.Write Server.MapPath("VD_Path\SQL") %> <% set oFso=Server.CreateObject("Scripting.FileSystemObject") For Each oFile In oFso.GetFolder(Server.MapPath("VD_PATH\SQL")).Files...
  14. vnad

    Bulk insert hangs at end of inserting (BCP)

    I am moving data out of a table using BCP to a file and then loading it back into a different table using BCP. I am moving about 5 million to 10 million per call. The data gets to the file quick enough (5-10 mins). The problem is with the load. It loads about 95 percent of the data, then it...
  15. vnad

    Event Viewer notifier

    Robomon is a application that can monitor the Event log and send SNMP traps or emails to certain people if a certain event occurs and posts to the event log. The maker of the software is heroix.
  16. vnad

    Possible to create one logical drive out of 2 physical drives?

    We are currently on a EMC SAN solution and the disk partitions get presented to our server. I heard of a way through windows to take two SAN partitions and concatenate them to one logical drive. Is this possible and how is it done? Thanks.
  17. vnad

    Performance hit when moved to 550GB drive

    Found out it was that the metavolume was on the same set of disks twice/three times. The original disk we were on, did not "loop" back on the same disks. Would this cause a large performance decrease? What is the typical size for a hypervolume?
  18. vnad

    Performance hit when moved to 550GB drive

    Are hypervolumes only used when the disks are setup to do parity? We are currently on mirrored disks.
  19. vnad

    Performance hit when moved to 550GB drive

    thanks for the quick reply They are using striping for sure and I think they are using metavols. What are the common mistakes made when configuring this?
  20. vnad

    Performance hit when moved to 550GB drive

    We are on a EMC Symmetrix and have been running great for over a year. We were running low on space, so we added a 550GB drive. When we copied our SQL Server database over to the drive, we lost about 40% in performance from the drive we were on (250GB) drive. We are using only one HBA (LP8000)...

Part and Inventory Search

Back
Top