User profile for mfal

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

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

Partition differences innacurate

We have a database in two different environment with a large partitioned table. The table has 5 indexes on it, 4 which are partitioned on one field, 1 which is partitioned differently. This was d...

2 followers 7 comments 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

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

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

SQL Server Base Monitoring service using excessive resources

We're having an issue where SQL monitor is continually consuming more and more memory, up to the max of 16 GB of the server. It takes about 15 minutes from start of the hosting machine to consume ...

6 followers 8 comments 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

How can we help you today?

mfal

Activity overview