User profile for mfal

These two statements are not what we're passing, they are the SQL output by SQL compare. Our create statements build the appropriate indexes on the same fields. / comments

These two statements are not what we're passing, they are the SQL output by SQL compare. Our create statements build the appropriate indexes on the same fields.

0 votes

Not sure what examples you're looking for, but Data Compare creates the following statements for our two environments: PROD CREATE TABLE [dbo].[ContractOrgItem] ( [ID] [bigint] NOT NULL IDENTITY(1, 1), [ContractOrgID] [int] NOT NULL, [VendorItemID] [bigint] NOT NULL, [UOM] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Quantity] [int] NOT NULL, [Price] [money] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL, [IsMyItem] [tinyint] NOT NULL CONSTRAINT [DF_ContractOrgItem_IsMyItem] DEFAULT ((0)), [Surcharge] [smallmoney] NOT NULL CONSTRAINT [DF_ContractOrgItem_Adjustment] DEFAULT ((0)) ) ON [ContractOrgIDPartScheme] ([ContractOrgID]) WITH (DATA_COMPRESSION = PAGE) GO DEV CREATE TABLE [dbo].[ContractOrgItem] ( [ID] [bigint] NOT NULL IDENTITY(1, 1), [ContractOrgID] [int] NOT NULL, [VendorItemID] [bigint] NOT NULL, [UOM] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Quantity] [int] NOT NULL, [Price] [money] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL, [IsMyItem] [tinyint] NOT NULL CONSTRAINT [DF_ContractOrgItem_IsMyItem] DEFAULT ((0)), [Surcharge] [smallmoney] NOT NULL CONSTRAINT [DF_ContractOrgItem_Adjustment] DEFAULT ((0)) ) ON [ContractOrgIDPartScheme] ([VendorItemID]) WITH (DATA_COMPRESSION = PAGE) GO Again, both of these tables and all indexes are partitioned in the same way as validated by my previously supplied query. So the question remains why Data Compare shows them as being different. / comments

Not sure what examples you're looking for, but Data Compare creates the following statements for our two environments:PROD CREATE TABLE [dbo].[ContractOrgItem] ( [ID] &#...

0 votes

I'm struggling with how to make this clear. Have you reviewed the repro script I attached to the second ticket(#4457)? As stated in the original post, we've created the same table in two different databases (one in each of our environments). Both tables were created with exactly the same SQL statements, partitioned the same way on the same fields as described in the initial post. SQL Compare, when reviewing the different tables (one in each environment) shows the two tables as being different when they're not, as validated by the system views query I posted initially. We would like to know why SQL Compare is incorrectly reporting a difference. Please let me know what I have not made clear. / comments

I'm struggling with how to make this clear. Have you reviewed the repro script I attached to the second ticket(#4457)? As stated in the original post, we've created the same table in two differen...

0 votes

Is there an alternate way to get the error logs? The monitor page is currently unresponsive due to the resource use. **EDIT: Found the text logs, attached them, email away.** / comments

Is there an alternate way to get the error logs? The monitor page is currently unresponsive due to the resource use. **EDIT: Found the text logs, attached them, email away.**

0 votes

The monitor services are on a virtual machine, but the instance hosting the database is not. We have not added any instances to Monitor for at least 2 weeks, and 2-3 weeks ago we had only added one instance to Monitor. That instance does reside on a 6 node cluster. / comments

The monitor services are on a virtual machine, but the instance hosting the database is not. We have not added any instances to Monitor for at least 2 weeks, and 2-3 weeks ago we had only added on...

0 votes

At this point I've allowed the services to run for 12 hours continuously. CPU is down to ~10% on the monitoring server, but RAM is still maxed out at 16 GB. The Monitor page is unresponsive. Please advise. / comments

At this point I've allowed the services to run for 12 hours continuously. CPU is down to ~10% on the monitoring server, but RAM is still maxed out at 16 GB. The Monitor page is unresponsive. Ple...

0 votes

I've got the instance highlighted. No matter which instance I highlight, it shows the same drive letter/mount point set and not the one assigned to that instance. / comments

I've got the instance highlighted. No matter which instance I highlight, it shows the same drive letter/mount point set and not the one assigned to that instance.

0 votes

The mountpoints do show up, but the problem is that for all instances only one set of cluster drives shows up (the O: drive). I'm looking for why only this drive would show and none of the other cluster drives would appear. / comments

The mountpoints do show up, but the problem is that for all instances only one set of cluster drives shows up (the O: drive). I'm looking for why only this drive would show and none of the other c...

0 votes

Thanks, I found it. If possible, for future releases, it would be nice to see the full blocking chain in a screen. I'm used to seeing that in other utilities. / comments

Thanks, I found it. If possible, for future releases, it would be nice to see the full blocking chain in a screen. I'm used to seeing that in other utilities.

0 votes

How can we help you today?

mfal

Comments